Scaling Postgres

By Creston JamisonTechnology

Scaling Postgres episodes

April 06, 2020 Ten Things, Audit Triggers, Schema Design, High Availability | Scaling Postgres 108
In this episode of Scaling Postgres, we discuss ten things to hate about Postgres, audit trigger performance, designing a schema and the future of high availability.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/108-ten-things-audit-triggers-schema-design-high-availability/
21 min
March 30, 2020 Showing Plans, Atomic, Configuration, Migrations | Scaling Postgres 107
In this episode of Scaling Postgres, we discuss how to show live query plans, the importance of atomic operations for scaling out, configuration options and DBaaS migrations.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/107-showing-plans-atomic-configuration-migrations/
11 min
March 23, 2020 Recursive CTEs, DB Access Patterns, Dates & Times, Cluster | Scaling Postgres 106
In this episode of Scaling Postgres, we discuss how to use recursive CTEs, database access patterns, using dates and times and how to cluster your data.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/106-recursive-cte-db-access-patterns-dates-times-cluster/
15 min
March 16, 2020 World's Best, Subtransactions, Sharding, Schema Changes | Scaling Postgres 105
In this episode of Scaling Postgres, we discuss how Postgres is the world's best database, performance ramifications of subtransactions, the current state of sharding and safe schema changes.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/105-worlds-best-subtransactions-sharding-schema-changes/
20 min
March 09, 2020 Reducing WAL, What is Null?, Understanding SQL, TPC-H Benchmarking | Scaling Postgres 104
In this episode of Scaling Postgres, we discuss how to reduce the size of your WAL files, what is null, how to better understand SQL and exploring TPC-H benchmarks.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/104-reducing-wal-what-is-null-understanding-sql-tpc-h-benchmarking/
16 min
March 02, 2020 Scaling Out, Planner Estimation, Create Statistics, Stay Curious | Scaling Postgres 103
In this episode of Scaling Postgres, we discuss how to scale out, how the planner estimates, uses of create statistics and investigating PostgreSQL run time environments.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/103-scaling-out-planner-estimation-create-statistics-stay-curious/
14 min
February 24, 2020 UUID Use Cases, pg_settings, Automated Restore, Parallel Future | Scaling Postgres 102
In this episode of Scaling Postgres, we discuss the use cases for UUIDs, using pg_settings, setting up an automated restore and the future of parallelism.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/102-uuid-use-cases-pg-settings-automated-restore-parallel-future/
13 min
February 17, 2020 Postgres Releases, Useless Vacuum, Isolation Differences, WAL Compression | Scaling Postgres 101
In this episode of Scaling Postgres, we discuss new postgres releases, useless vacuuming, isolation differences between databases, and different ways to compress WAL files.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/101-postgres-releases-useless-vacuum-isolation-differences-wal-compression/
18 min
February 10, 2020 Full Text Search, Query Optimization, Exception Blocks, Procedural Language | Scaling Postgres 100
In this episode of Scaling Postgres, we discuss full text search, a process for query optimization, caution with exception blocks and adding a procedural language.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/100-full-text-search-query-optimization-exception-blocks-procedural-language/
16 min
February 03, 2020 Ballad of Bloat, Auditing Options, Configuration Options, Need Vacuum? | Scaling Postgres 99
In this episode of Scaling Postgres, we discuss the "Ballad of Bloat", options for auditing, a configuration help resource and determining when a vacuum is needed.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/99-ballad-of-bloat-auditing-options-configuration-options-need-vacuum/
16 min

About Scaling Postgres

From the publisher's feed

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers…