Episode 199 Shaped Sample Data | Version Changes | Missed Bottlenecks | Indexes for Newbies

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://blog.timescale.com/blog/how-to-shape-sample-data-with-postgresql-generate_series-and-sql/"> https://blog.timescale.com/blog/how-to-shape-sample-data-with-postgresql-generate_series-and-sql/</a><br /> <br /> <a href= "https://www.depesz.com/2022/01/17/configuration-changes-across-pg-versions/"> https://www.depesz.com/2022/01/17/configuration-changes-across-pg-versions/</a><br /> <br /> <a href= "https://pawelurbanek.com/postgresql-query-bottleneck">https://pawelurbanek.com/postgresql-query-bottleneck</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/postgres-indexes-for-newbies">https://blog.crunchydata.com/blog/postgres-indexes-for-newbies</a><br /> <br /> <a href= "https://www.depesz.com/2022/01/17/waiting-for-postgresql-15-introduce-log_destinationjsonlog/"> https://www.depesz.com/2022/01/17/waiting-for-postgresql-15-introduce-log_destinationjsonlog/</a><br /> <br /> <a href= "http://rhaas.blogspot.com/2022/01/surviving-without-superuser-part-two.html"> http://rhaas.blogspot.com/2022/01/surviving-without-superuser-part-two.html</a><br /> <br /> <a href= "https://www.shayon.dev/post/2022/17/why-i-enjoy-postgresql-infrastructure-engineers-perspective/"> https://www.shayon.dev/post/2022/17/why-i-enjoy-postgresql-infrastructure-engineers-perspective/</a><br /> <br /> <a href= "https://aws.amazon.com/blogs/database/postgresql-bi-directional-replication-using-pglogical/"> https://aws.amazon.com/blogs/database/postgresql-bi-directional-replication-using-pglogical/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/data-normalization-in-postgresql/"> https://www.cybertec-postgresql.com/en/data-normalization-in-postgresql/</a><br /> <br /> <a href= "https://postgr