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 102

February 24, 2020 00:12:44
Episode Cover

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

Listen

Episode 381

August 31, 2025 00:09:44
Episode Cover

DocumentDB Movement | Scaling Postgres 381

In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities. To get...

Listen

Episode 37

November 05, 2018 00:17:35
Episode Cover

Postgres Goodies, Materialized vs Rollup, Column Oriented | Scaling Postgres 37

In this episode of Scaling Postgres, we review articles covering Postgres goodies, materialized vs. rollup, column oriented data and parallel scans. To get the...

Listen