30% Faster, UUID Downsides, Growing WAL, Processes vs. Threads

Scaling Postgres

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

Jun 26 2023 | 00:16:24

00:00 / 00:16:24

Hosted By

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 124

July 27, 2020 • 00:15:56

Partition Migration, Like Performance, Best Fillfactor, In-Memory Tables | Scaling Postgres 124

In this episode of Scaling Postgres, we discuss how best to migrate to using partitions, like & ilike performance, determining the best fillfactor and...

Episode 210

April 10, 2022 • 00:09:52

Date Time Bins, Search Every Field, JSON_TABLE, Picking Primary | Scaling Postgres 210

In this episode of Scaling Postgres, we discuss how to bin date times, search every field of a table, use JSON_TABLE and methods for...

Episode 62

May 05, 2019 • 00:15:39

Index Include Clause, Exporting CSV, JSON, Zedstore | Scaling Postgres 62

In this episode of Scaling Postgres, we review articles covering the index include clause, exporting data to CSV, using JSON in Postgres and Zedstore....