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 since your architecture and usage is the key to getting the most performance out of PostgreSQL.
…
continue reading
1
Optimizing For Analytics | Scaling Postgres 334
21:55
21:55
Play later
Play later
Lists
Like
Liked
21:55
In this episode of Scaling Postgres, we discuss how to optimize your database for analytics, how to speed up counts, improvements to TimescaleDB and why you should stop using serial. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/334-optimizing-for-analytics/ Want to learn more about P…
…
continue reading
1
When Select Writes! | Scaling Postgres 333
13:38
13:38
Play later
Play later
Lists
Like
Liked
13:38
In this episode of Scaling Postgres, we discuss when select can write, Postgres RC1 is released, Tetris in SQL and copy, swap, drop. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/333-when-select-writes/ Want to learn more about Postgres performance? Join my FREE training called Postgr…
…
continue reading
1
Sometimes It Is Slow? | Scaling Postgres 332
15:10
15:10
Play later
Play later
Lists
Like
Liked
15:10
In this episode of Scaling Postgres, we discuss what can happen when queries get slow, backup best practices, Postgres emergencies and the state of Postgres survey. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/332-sometimes-it-is-slow/ Want to learn more about Postgres performance? J…
…
continue reading
1
Is pg_dump A Backup Tool? | Scaling Postgres 331
17:31
17:31
Play later
Play later
Lists
Like
Liked
17:31
In this episode of Scaling Postgres, we discuss whether pg_dump is a backup tool, the pgMonitor extension, Postgres malware, and application uses for the merge command. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/331-is-pg_dump-a-backup-tool/ Want to learn more about Postgres perfor…
…
continue reading
1
Splicing Elephant & Duck DNA | Scaling Postgres 330
14:58
14:58
Play later
Play later
Lists
Like
Liked
14:58
In this episode of Scaling Postgres, we discuss the merging of Postgres and DuckDB via the pg_duckdb extension, how this can help the analytics story for Postgres, some ways to improve PG analytics and building a search engine. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/330-splicin…
…
continue reading
1
PGlite: Embeddable Postgres & postgres.new | Scaling Postgres 329
19:01
19:01
Play later
Play later
Lists
Like
Liked
19:01
In this episode of Scaling Postgres, we discuss PGlite, an embeddable Postgres, postgres.new which adds AI features, new Postgres releases and the performance of synchronous replication. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/329-pglite-embeddable-postgres/ Want to learn more a…
…
continue reading
1
Implement Get Or Create | Scaling Postgres 328
16:10
16:10
Play later
Play later
Lists
Like
Liked
16:10
In this episode of Scaling Postgres, we discuss different get or create implementations, a new pgBouncer version, alter default privileges, and six degrees of separation with Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/328-implement-get-or-create/ Want to learn more about …
…
continue reading
1
Postgres Graph Queries | Scaling Postgres 327
16:30
16:30
Play later
Play later
Lists
Like
Liked
16:30
In this episode of Scaling Postgres, we discuss using Postgres for graph queries, the fastest way to copy data from one table to another, dealing with linux memory overcommit and compression. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/327-postgres-graph-queries/ Want to learn more …
…
continue reading
1
Faster Index Creation | Scaling Postgres 326
20:28
20:28
Play later
Play later
Lists
Like
Liked
20:28
In this episode of Scaling Postgres, we talk about speeding up index creation, extensions to track wait events, a row pattern recognition feature and savepoints. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/326-faster-index-creation/ Want to learn more about Postgres performance? Joi…
…
continue reading
In this episode of Scaling Postgres, we discuss more ways to keep the superior performance of keyset pagination, how to implement UUIDv7 in SQL functions, how expensive extended statistics are and the benefits of range columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/325-faster-…
…
continue reading
In this episode of Scaling Postgres, we discuss experiments to achieve four million transaction per second, the importance of extended statistics, parallelism in Postgres and an introduction to window functions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/324-four-million-tps/ Want …
…
continue reading
1
PgBouncer Breaking Change | Scaling Postgres 323
23:47
23:47
Play later
Play later
Lists
Like
Liked
23:47
In this episode of Scaling Postgres, we discuss a breaking change in the new version of PgBouncer, PostgreSQL 17 Beta 2 is released, examination of the new built-in collation provider in PG 17 and Notion's data lake. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/323-pgbouncer-breaking…
…
continue reading
1
Postgres Sort Instability? | Scaling Postgres 322
19:48
19:48
Play later
Play later
Lists
Like
Liked
19:48
In this episode of Scaling Postgres, we discuss an incremental sort instability issue with the Postgres planner, whether we should use foreign keys, how the visibility map works and how to vacuum the template0 database. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/322-postgres-sort-i…
…
continue reading
1
Ottertune Is Dead! | Scaling Postgres 321
11:02
11:02
Play later
Play later
Lists
Like
Liked
11:02
In this episode of Scaling Postgres, we discuss the shutdown of Ottertune, how schema changes cause locks and how to avoid them, the benefits of on conflic do nothing, and pgvectorscale. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/321-ottertune-is-dead/ Want to learn more about Post…
…
continue reading
1
100 TB and Beyond! | Scaling Postgres 320
17:32
17:32
Play later
Play later
Lists
Like
Liked
17:32
In this episode of Scaling Postgres, we discuss three organizations scaling their databases to 100 TB and beyond, collation speed, configuring memory and new AI extensions To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/320-100tb-and-beyond/ Want to learn more about Postgres performance…
…
continue reading
1
When Postgres Development Stopped! | Scaling Postgres 319
12:05
12:05
Play later
Play later
Lists
Like
Liked
12:05
In this episode of Scaling Postgres, we discuss a time when Postgres development stopped, two new extensions pg_lakehouse & pg_compare and the upcoming event Posette. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/319-when-postgres-development-stoppped/…
…
continue reading
1
Postgres 17 Beta 1 Released | Scaling Postgres 318
17:54
17:54
Play later
Play later
Lists
Like
Liked
17:54
In this episode of Scaling Postgres, we discuss all the new features in Postgres 17 Beta 1, some features that did not make it, database collations & sorting and causes of slow commits. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/318-postgres-17-beta-1-released/…
…
continue reading
1
Time-Series Open Source Extension | Scaling Postgres 317
14:56
14:56
Play later
Play later
Lists
Like
Liked
14:56
In this episode of Scaling Postgres, we discuss a new time-series open source extension called pg_timeseries, Postgres ignoring indexes, JSONB selectivity issues, and geographically distributed multi-tenant applications. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/317-time-series-op…
…
continue reading
1
New Releases & 1,000 Times Faster Query | Scaling Postgres 316
14:34
14:34
Play later
Play later
Lists
Like
Liked
14:34
In this episode of Scaling Postgres, we discuss new Postgres releases, optimizing a query to be 1,000 times faster, custom vs. generic plans and the pgtt extension. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/316-new-releases-1000-times-faster-query/…
…
continue reading
1
Hacking On Postgres is Hard! | Scaling Postgres 315
19:31
19:31
Play later
Play later
Lists
Like
Liked
19:31
In this episode of Scaling Postgres, we discuss how hacking on Postgres is hard, a notifier pattern for using Listen/Notify, using histograms for metrics and saturated arithmetic. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/315-hacking-on-postgres-is-hard/…
…
continue reading
1
150 Times Faster pgvector? | Scaling Postgres 314
16:30
16:30
Play later
Play later
Lists
Like
Liked
16:30
In this episode of Scaling Postgres, we discuss performance improvements for pgvector 0.7.0, a guide to vector embeddings, building a Retrieval Augmented Generation app and only allow logins to replicas. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/314-150-times-faster-pgvector/…
…
continue reading
1
The Future of MySQL is Postgres? | Scaling Postgres 313
15:33
15:33
Play later
Play later
Lists
Like
Liked
15:33
In this episode of Scaling Postgres, we discuss whether the future of MySQL is Postgres, how to use recursive CTEs, work on OrioleDB, and PG17 performance improvements. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/313-the-future-of-mysql-is-postgres/…
…
continue reading
1
Postgres 17 Commit-orama | Scaling Postgres 312
12:57
12:57
Play later
Play later
Lists
Like
Liked
12:57
In this episode of Scaling Postgres, we cover potential features in Postgres 17 such as explain serialize, verbose copy, pg_buffer_cache_evict, as well as many others. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/312-postgres-17-commit-orama/…
…
continue reading
1
1,400 Times Faster Max & Group By Performance | Scaling Postgres 311
18:52
18:52
Play later
Play later
Lists
Like
Liked
18:52
In this episode of Scaling Postgres, we discuss a 1,400 times faster max and group by implementation, new quantization capabilities in pgvector, adaptive radix trees and splitting & merging partitions in PG17. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/311-max-group-by-performance/…
…
continue reading
1
Andres, Microsoft & Postgres Save Linux? | Scaling Postgres 310
12:55
12:55
Play later
Play later
Lists
Like
Liked
12:55
In this episode of Scaling Postgres, we discuss whether Postgres will pull a Redis, remembering Simon Riggs, built-in collation provider and C.UTF-8 in PG 17 and health checks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/310-andres-microsoft-postgres-save-linux/…
…
continue reading
1
Will Postgres Pull A Redis? | Scaling Postgres 309
15:12
15:12
Play later
Play later
Lists
Like
Liked
15:12
In this episode of Scaling Postgres, we discuss whether Postgres will pull a Redis, remembering Simon Riggs, built-in collation provider and C.UTF-8 in PG 17 and health checks. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/309-will-postgres-pull-a-redis/…
…
continue reading
1
Scale Through Sharding | Scaling Postgres 308
18:15
18:15
Play later
Play later
Lists
Like
Liked
18:15
In this episode of Scaling Postgres, we discuss high availability's future, a custom sharding solution by Figma, sharding pg_vector queries, and PG17 logical replication failover. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/308-scale-through-sharding/…
…
continue reading
1
Collation Conundrum | Scaling Postgres 307
14:22
14:22
Play later
Play later
Lists
Like
Liked
14:22
In this episode of Scaling Postgres, we discuss whether we should be using bytewise or linguistic ordering by default, how to transform data in Postgres, benefits of a transaction_timeout and how to enforce join order. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/307-collation-conund…
…
continue reading
1
Scalability Limits From SLRU & Lock Manager | Scaling Postgres 306
14:29
14:29
Play later
Play later
Lists
Like
Liked
14:29
In this episode of Scaling Postgres, we discuss one configuration change that resulted in an 11,000 times faster query, why Postgres is not using your index, backported PG improvements and parallelism with TOAST. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/306-scalability-limits-fro…
…
continue reading
1
11K Faster Configuration Change | Scaling Postgres 305
13:26
13:26
Play later
Play later
Lists
Like
Liked
13:26
In this episode of Scaling Postgres, we discuss one configuration change that resulted in an 11,000 times faster query, why Postgres is not using your index, backported PG improvements and parallelism with TOAST. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/305-11k-faster-configurati…
…
continue reading
1
Overhead of pg_stat_statements | Scaling Postgres 304
14:09
14:09
Play later
Play later
Lists
Like
Liked
14:09
In this episode of Scaling Postgres, we discuss new Postgres releases, performance comparisons between PgBouncer, PgCat and Supavisor, a new extension pg_analytics, and new planner capabilities in PG16. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/304-overhead-of-pg_stat_statements/…
…
continue reading
1
PgBouncer, PgCat, Supavisor Fight!!! | Scaling Postgres 303
19:55
19:55
Play later
Play later
Lists
Like
Liked
19:55
In this episode of Scaling Postgres, we discuss new Postgres releases, performance comparisons between PgBouncer, PgCat and Supavisor, a new extension pg_analytics, and new planner capabilities in PG16. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/303-pgbouncer-pgcat-supavisor-fight/…
…
continue reading
1
UUID vs Bigint Battle!!! | Scaling Postgres 302
13:23
13:23
Play later
Play later
Lists
Like
Liked
13:23
In this episode of Scaling Postgres, we discuss when and how you should use UUIDs or not, how to optimize space with column order and arrays, whether it is better to tune parameters or queries and what devs should know about Postgres with Andrew Atkinson. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostg…
…
continue reading
1
Postgres LLM OS & 30 Times Faster Index Builds | Scaling Postgres 301
18:14
18:14
Play later
Play later
Lists
Like
Liked
18:14
In this episode of Scaling Postgres, we discuss how you can build a GPT in 500 lines of SQL code, how to optimize extension loading, the best way to set passwords and being able to change generated columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/301-postgres-llm-os-30-times-fas…
…
continue reading
1
Scaling Postgres Celebration | Scaling Postgres 300
18:02
18:02
Play later
Play later
Lists
Like
Liked
18:02
In this episode of Scaling Postgres, we discuss how you can build a GPT in 500 lines of SQL code, how to optimize extension loading, the best way to set passwords and being able to change generated columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/300-postgres-celebration/…
…
continue reading
1
Build A GPT In SQL | Scaling Postgres 299
12:21
12:21
Play later
Play later
Lists
Like
Liked
12:21
In this episode of Scaling Postgres, we discuss how you can build a GPT in 500 lines of SQL code, how to optimize extension loading, the best way to set passwords and being able to change generated columns. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/299-build-a-gpt-in-sql/…
…
continue reading
1
10-100 Times Higher Latency With Distributed Postgres | Scaling Postgres 298
19:28
19:28
Play later
Play later
Lists
Like
Liked
19:28
In this episode of Scaling Postgres, we discuss hopes for Postgres in 2024, whether you need foreign keys, incremental backups, and five ways of doing not exists. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/298-10-100-times-higher-latency-with-distributed-postgres/…
…
continue reading
In this episode of Scaling Postgres, we discuss hopes for Postgres in 2024, whether you need foreign keys, incremental backups, and five ways of doing not exists. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/297-postgres-in-2024/By Creston Jamison
…
continue reading
1
State Of Postgres 2023 | Scaling Postgres 296
17:45
17:45
Play later
Play later
Lists
Like
Liked
17:45
In this episode of Scaling Postgres, we discuss the State of Postgres 2023 survey, a repository of Postgres how-tos, ways foreign keys can break and a custom SQL playground. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/296-state-of-postgres-2023/…
…
continue reading
1
30K Messages Per Second Queue | Scaling Postgres 295
15:32
15:32
Play later
Play later
Lists
Like
Liked
15:32
In this episode of Scaling Postgres, we discuss a 30K messages per second queue built on Postgres, a zero downtime logical replication upgrade, the release of the Supavisor 1.0 connection pooler and PostGIS day. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/295-30k-messages-per-second…
…
continue reading
1
How Much Observability Is Needed? | Scaling Postgres 294
14:09
14:09
Play later
Play later
Lists
Like
Liked
14:09
In this episode of Scaling Postgres, we discuss how much observability is needed, avoiding locks during database migrations, a huge Postgres events blogging event and FIPS mode. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/294-how-much-observability-is-needed/…
…
continue reading
1
Better Plans With Statistics | Scaling Postgres 293
15:18
15:18
Play later
Play later
Lists
Like
Liked
15:18
In this episode of Scaling Postgres, we discuss how create statistics can help you get better plans, issues with subtransactions, all about extensions and best practices when indexing timestamps. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/293-better-plans-with-statistics/…
…
continue reading
1
Companion Databases? | Scaling Postgres 292
13:13
13:13
Play later
Play later
Lists
Like
Liked
13:13
In this episode of Scaling Postgres, we discuss using companion databases, multi-tenancy database design, whether SQL is good, and different transaction isolation levels. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/292-companion-databases/…
…
continue reading
1
2 To 4 Times Faster With Vectorization | Scaling Postgres 291
18:15
18:15
Play later
Play later
Lists
Like
Liked
18:15
In this episode of Scaling Postgres, we discuss Timescale's performance improvements from adding a query vectorization pipeline, doing blue-green deployments for databases, using reserved_connections and two improvements to null handling. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/…
…
continue reading
1
Postgres Releases = Reindexing | Scaling Postgres 290
14:22
14:22
Play later
Play later
Lists
Like
Liked
14:22
In this episode of Scaling Postgres, we discuss my Postgres Performance Starter Kit, new releases of Postgres, removing JIT, and a lightweight message queue. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/290-postgres-releases-equals-reindexing/…
…
continue reading
1
Postgres Scheduling Opportunities | Scaling Postgres 289
15:19
15:19
Play later
Play later
Lists
Like
Liked
15:19
In this episode of Scaling Postgres, we discuss new options for Postgres scheduling tools, proper ways to kill processes and explain usage. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/289-postgres-scheduling-opportunities/By Creston Jamison
…
continue reading
1
Index Corruption From ICU Collation Change | Scaling Postgres 288
19:02
19:02
Play later
Play later
Lists
Like
Liked
19:02
In this episode of Scaling Postgres, we discuss index corruption from a ICU collation change, another caveat for PgBouncer prepared statements, ways to version data, and using Postgres as a cache. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/288-index-corruption-from-icu-collation-ch…
…
continue reading
1
15% - 250% Faster Query Throughput | Scaling Postgres 287
14:25
14:25
Play later
Play later
Lists
Like
Liked
14:25
In this episode of Scaling Postgres, we discuss how the new version of pgbouncer could get you 15% to 250% faster query throughput, the availability of using kubernetes snapshots for backup and restore with CloudNativePg and Ruby on Rails Postgres improvements. To get the show notes as well as get notified of new episodes, visit: https://www.scalin…
…
continue reading
1
20 Times Faster Text Search & Ranking? | Scaling Postgres 286
12:59
12:59
Play later
Play later
Lists
Like
Liked
12:59
In this episode of Scaling Postgres, we discuss a new extension that promises substantially faster text search and ranking, an AI content storm, how to work with money and the fastest way to stop Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/286-20-times-faster-text-search-r…
…
continue reading
1
Indexing Deep Dive | Scaling Postgres 285
18:02
18:02
Play later
Play later
Lists
Like
Liked
18:02
In this episode of Scaling Postgres, we cover a deep dive into indexes from a presentation that includes a decision tree of sorts, how to convert to partitioned tables once you have hundreds of millions of rows and detail about the new pg_stat_io view. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres…
…
continue reading