Storage strategy: rotating daily partitions

Nik and Michael discuss pg_ash — a new tool (not extension!) from Nik that samples and stores wait events from pg_stat_activity.
 
Here are some links to things they mentioned: 

• pg_ash https://github.com/NikolayS/pg_ash
• pg_wait_sampling https://github.com/postgrespro/pg_wait_sampling
• Amazon RDS performance insights https://aws.amazon.com/rds/performance-insights
• Our episode on wait events https://postgres.fm/episodes/wait-events
• pg-flight-recorder https://github.com/dventimisupabase/pg-flight-recorder
• pg_profile https://github.com/zubkov-andrei/pg_profile
• pg_cron https://github.com/citusdata/pg_cron

~~~

What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!

~~~

Postgres FM is produced by:

• Michael Christofides, founder of pgMustard
• Nikolay Samokhvalov, founder of Postgres.ai

With credit to:

• Jessie Draws for the elephant artwork