Shaped Sample Data, Version Changes, Missed Bottlenecks, Indexes for Newbies | Scaling Postgres 199
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-postgresql/
https://postgresql.life/post/kuntal_ghosh/
https://www.rubberduckdevshow.com/episodes/26-the-dark-side-of-open-source/
Create your
podcast in
minutes
It is Free