Scaling Postgres

In this episode of Scaling Postgres, we discuss how to generate shaped sample data, track changes between Postgres versions, identify missed bottlenecks and use different index types. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://blog.timescale.com/blog/how-to-shape-sample-data-with-postgresql-generate_series-and-sql/ https://www.depesz.com/2022/01/17/configuration-changes-across-pg-versions/ https://pawelurbanek.com/postgresql-query-bottleneck https://blog.crunchydata.com/blog/postgres-indexes-for-newbies https://www.depesz.com/2022/01/17/waiting-for-postgresql-15-introduce-log_destinationjsonlog/ http://rhaas.blogspot.com/2022/01/surviving-without-superuser-part-two.html https://www.shayon.dev/post/2022/17/why-i-enjoy-postgresql-infrastructure-engineers-perspective/ https://aws.amazon.com/blogs/database/postgresql-bi-directional-replication-using-pglogical/ https://www.cybertec-postgresql.com/en/data-normalization-in-post