Scaling Postgres

In this episode of Scaling Postgres, we discuss a new version of pgbouncer, query parameter types, a performance improvement from a lateral join and security invoker views.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/208-pgbouncer-released-query-parameter-types-lateral-joins-security-invoker-views/

In this episode of Scaling Postgres, we discuss how best to configure autovacuum, the dangers of duplicate key violations, how to set up pipelining, and how to tune max_wal_size.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/207-autovacuum-configuration-dupliate-key-violations-pipelining-tuning-max_wal_size/

In this episode of Scaling Postgres, we discuss 100x optimizations, how to audit table activity, designing schemas and how to set up table checksums.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/206-100x-optimizations-auditing-document-schema-designs-checksums/

In this episode of Scaling Postgres, we discuss the best ways to index with tsearch, what to check if tuples are not yet removable, wicked problems with Postgres and different pattern matching techniques.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/205-indexing-with-tsearch-tuples-not-yet-removable-wicked-problems-pattern-matching/

In this episode of Scaling Postgres, we discuss optimizing trigram searches, a review of Postgres replication, improvements to logical replication and a significant Timescale investment.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/204-optimizing-trigram-search-replication-review-logical-improvements-timescale-investment/

In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and using loadable modules for WAL archiving.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/203-saving-space-working-with-toast-protecting-data-high-cpu-utilization/

In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and using loadable modules for WAL archiving.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/202-new-postgres-releases-hairy-incident-slow-down-to-go-faster-loadable-module-archiving/

In this episode of Scaling Postgres, we discuss JSONB performance, bidirectional replication, getting the most recent record and using JSON in Postgres 14.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/201-jsonb-performance-bidirectional-replication-most-recent-record-pg14-json/

In this episode of Scaling Postgres, we discuss the new series 5 minutes of Postgres, using unnest, switching to SCRAM authentication and reviewing multi-master solutions.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/200-5-minute-postgres-unnest-scram-multi-master-review/

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.

To get the show notes as well as get notified of new episodes, visit:

https://www.scalingpostgres.com/episodes/199-shaped-sample-data-version-changes-missed-bottlenecks-indexes-for-newbies/