30% Faster, UUID Downsides, Growing WAL, Processes vs. Threads | Scaling Postgres 271

Episode 271 • June 26, 2023 • 00:16:24
30% Faster, UUID Downsides, Growing WAL, Processes vs. Threads | Scaling Postgres 271
Scaling Postgres
30% Faster, UUID Downsides, Growing WAL, Processes vs. Threads | Scaling Postgres 271

Jun 26 2023 | 00:16:24

/

Hosted By

Creston Jamison

Show Notes

 

In this episode of Scaling Postgres, we discuss how to get 30% faster performance, the downsides of UUIDs, having too much WAL and whether Postgres should use processes or threads.

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

https://www.scalingpostgres.com/episodes/271-30-percent-faster-uuid-downsides-growing-wal-processes-vs-threads/

Previous Episode
Next Episode

Other Episodes

Episode 350

January 26, 2025 • 00:19:09
Episode Cover

Seven Years of Scaling Postgres | Scaling Postgres 350

In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group...

Listen

Episode 19

July 02, 2018 • 00:17:42
Episode Cover

100K Tenants, Extensions, Query Planning, Crosstabs | Scaling Postgres 19

In this episode of Scaling Postgres, we review articles covering 100,000 tenants, Postgres Extensions, query planning and how to create crosstabs. To get the...

Listen

Episode 41

December 03, 2018 • 00:14:26
Episode Cover

Sequential UUIDs, Runnning Totals, Read Committed, TOAST | Scaling Postgres 41

In this episode of Scaling Postgres, we review articles covering sequential UUIDs, running totals with window functions, read committed vs repeatable read and TOAST....

Listen