Bertrand Drouvot

2/2 3. leverage system views: I think it would make sense to add “and state = ‘active’” in the query. As if not “active” the query will show the last wait event when the session “was” active.

1/2 Thanks Kellyn! Yeah that looks good, thanks! Just 3 remarks ;-) : 1. for most PostgreSQL databases: for PostgreSQL databases versions greater or equal to 10.
2. s/Drovout/Drouvot

wait_event_type is documented here www.postgresql.org/docs/current... and here www.postgresql.org/docs/current... It's not named "class" as on Oracle but that's the same i.e a way to group by type/category.

@dbakevlar.bsky.social not sure what you mean by "There is no official grouping into wait classes". You can see the wait event type as the wait class:

If you received the message seen below, please be aware that this individual is in no way affiliated with me, or my employer, and was not requested or authorized to recruit on our behalf. Please accept my sincerest apologies for the possibly comical, probably annoying, intrusion into your DMs

PGConf NYC 2025 | PostgreSQL Conference PGConf NYC 2025 will be held from on September 29th - October 1st in New York City, NY at Convene 117 West 46th Street.

Big news: PGConf NYC 2025 is extending its talk submission deadline to June 4th! Submit your proposal, and join us in NYC this fall!

👉

See you in 2026 https://www.pgevents...

Looking for a way to become involved in the #PostgreSQL community? I've created a Wiki page with several ideas, as well as information on how to become involved with your particular area of interest.

wiki.postgresql.org/wiki/Volunteer

It's a Wiki page, you can add any missing ones! Thanks!

PGConf NYC 2025 | PostgreSQL Conference PGConf NYC 2025 will be held from on September 29th - October 1st in New York City, NY at Convene 117 West 46th Street.

PGConf NYC is looking for talk submissions from app developers, first-time query runners, DBAs, open source contributors, and more. Our audience includes PostgreSQL users of all experience levels!

2025.pgconf.nyc/callforpapers/

@PostgreSQL #postgres #conference

Postgres backend statistics (Part 2): WAL statistics Introduction PostgreSQL 18 will normally (as there is always a risk of seeing something reverted until its GA release) include those commits: Add data for WAL in pg_stat_io and backend statistics:…

#PostgreSQL backend statistics (Part 2): WAL statistics. Blog post:

It's almost here! Come see Pavlo Golub (@pavlogolub.bsky.social) talk about "Professional PostgreSQL monitoring made easy"!

#pgDayParis #PostgreSQL

https://www.postgres...

Looking forward to the whole #pgDayParis #PostgreSQL day!

Bio pic of Talking Postgres podcast guest & PostgreSQL committer Robert Haas who joined for Episode 24 to talk about mentoring in PostgreSQL

New episode of #TalkingPostgres #podcast

#PostgreSQL committer Robert Haas joined to talk about mentoring in Postgres: why it matters, his own experiences, what would Tom Lane do, the new PostgreSQL Hackers Mentoring program, & more

🎧 talkingpostgres.com/episodes/why...

📺 youtu.be/4wSDnx8di6o?...

Je ne suis donc pas le seul ! ;-)

Bio pics of Robert Haas, the guest on Episode 24 of the Talking Postgres podcast, as well as a bio pic of Claire Giordano, the host of the show. Also displays the date and time for the live recording of Episode 24 about Why mentor Postgres developers. (Date is Wed Feb 5th and time is 10:00am PST)

Happening Wed Feb 5 at 10am PST, a LIVE recording of Ep24 of the #TalkingPostgres #podcast w/guest Robert Haas, a #PostgreSQL major contributor & committer. Topic = Why mentor Postgres developers?

Join us LIVE on Discord—or subscribe to the pod & listen after E24 is published aka.ms/TalkingPostg...

Trip booked, looking forward to it!

Unless the others close at 9pm? ;-)

The schedule for pgDay Paris 2025 is now live! We are proud to feature a diverse range of speakers and topics. Check out the schedule and register now to secure your spot.
#pgdayparis #schedule #postgresql

https://www.postgresql.eu/events/pgdayparis2025/schedule/

Adding the #PostgreSQL 17 contributor coin to my collection. Thank you #PostgreSQL Funds group!

Exciting news! The schedule for pgDay Paris 2025 drops next week and we still have a few Blind & Early Bird tickets available—Secure your spot now and stay tuned for the full program! 👉 https://2025.pgday.paris/registration/ #PostgreSQL #conference #pgDayParis

Postgres backend statistics (Part 1): I/O statistics Introduction PostgreSQL 18 will normally (as there is always a risk of seeing something reverted until its GA release) include this commit: Add backend-level statistics to pgstats. commit…

#PostgreSQL backend statistics (Part 1): I/O statistics. Blog post:

postgresintl.blogspot.com/2024/12/does...

We upgraded to Postgres 17 last week and I ran numbers for real life perf gains over the ~9 days worth of API telemetry since.

They are looking VERY good, with a 15% reduction in request duration at P50. Even better than my synthetic bench a few months back.

Writeup to come.

pgDay Paris 2025 A 1-day PostgreSQL community conference in Paris, France.

Just submitted talks for 3 #PostgreSQL conferences:

https://buff.ly/4ij1Fgx
https://buff.ly/49p41GL
https://buff.ly/41CUjyH

Sadly I missed the #fosdem train ;-( (but will attend anyway).

Can a User Process Consume Kernel Mode CPU Without a Syscall?

(yes)

tanelpoder.com/posts/user-p...

PGConf.dev 2025

The PGConf.dev 2025 call for proposals and sponsors is open! Submit your talk ideas about the future of #PostgreSQL (development, community, and more!) now through Jan 1, 2025. More details here:
www.postgresql.org/about/news/p...