Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255

Episode 255 • March 05, 2023 • 00:17:43
Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255
Scaling Postgres
Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255

Mar 05 2023 | 00:17:43

/

Hosted By

Creston Jamison

Show Notes

In this episode of Scaling Postgres, we discuss how to detect & handle integer overflows, a wish for user-friendly permissions, using a dump to start logical replication and configuring background workers.

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

https://www.scalingpostgres.com/episodes/255-integer-overflow-user-friendly-permissions-dump-logical-replication-worker-config/

Previous Episode
Next Episode

Other Episodes

Episode 364

May 04, 2025 • 00:20:39
Episode Cover

Scaling For High Volume | Scaling Postgres 364

In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to...

Listen

Episode 5

March 26, 2018 • 00:14:44
Episode Cover

Constraints, User Order, PG Terrible, Logical Upgrades | Scaling Postgres 5

In this episode of Scaling Postgres, we review articles covering database constraints, user defined ordering, how PostgreSQL is terrible, TimeScaleDB and using logical replication...

Listen

Episode 24

August 06, 2018 • 00:12:31
Episode Cover

Full Text Search, JSONB_AGG, Upgrades, CIS | Scaling Postgres 24

In this episode of Scaling Postgres, we review articles covering full text search, aggregating JSON with jsonb_agg, upgrades and CIS benchmarks. To get the...

Listen