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 93

December 09, 2019 • 00:09:04
Episode Cover

Logical Replication, Monitoring Queries, SQL Beautifier, Incomplete Startup Packet | Scaling Postgres 93

In this episode of Scaling Postgres, we discuss logical replication aspects, how to monitor queries, investigating a SQL beautifier and removing incomplete startup packet....

Listen

Episode 231

September 04, 2022 • 00:19:03
Episode Cover

PG15 Public Schema, Kubernetes Experiences, Dump Manifests, PgBouncer Fork | Scaling Postgres 231

In this episode of Scaling Postgres, we discuss the PG15 changes to public schema permissions, experiences with kubernetes for Postgres management, using dump manifests...

Listen

Episode 193

November 28, 2021 • 00:09:26
Episode Cover

Entity-Attribute-Value Design, JSON Subscripting, mysql-fdw Push-down, New Regex | Scaling Postgres 193

In this episode of Scaling Postgres, we discuss using entity-attribute-value designs, new JSON subscripting capabilities, the mysql-fdw support for aggregate pushdowns and new regex...

Listen