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/

Other Episodes

Episode 310

April 07, 2024 • 00:12:55
Episode Cover

Andres, Microsoft & Postgres Save Linux? | Scaling Postgres 310

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...

Listen

Episode 407

March 08, 2026 • 00:18:48
Episode Cover

Stable Plans? | Scaling Postgres 407

In this episode of Scaling Postgres, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or crashed clients,...

Listen

Episode 361

April 13, 2025 • 00:17:28
Episode Cover

A Roadmap To Scaling Postgres | Scaling Postgres 361

In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs...

Listen