Postgres FM19 Mai 2023

Corruption

Nikolay and Michael discuss database corruption — various types, how they can come about, and what to do (and not do) if you come across it.

Here are links to a few things we mentioned:

The dangers of streaming across versions of glibc (TripAdvisor mailing list thread)
The floor is Java meme
Data Corruption talk by Sebastian Webber (on Postgres TV)
Data corruption monitoring & troubleshooting talk by Andrey Borodin (on Postgres TV)
Postgres data corruption (document from Nikolay)
Data Corruption and Bugs Runbook (document from Nikolay)
Corruption (Postgres wiki)
Checksums
pg_checksums
Original pg_checksums (by Credativ)
amcheck
Our episode on index maintenance
14.4 release notes about create index / reindex concurrently issue and fix
amcheck to check unique constraints in btree indexes (Commitfest entry)
amcheck verification of GiST and GIN (Commitfest entry)
How to corrupt your Postgres database (blog post from Cybertec)
Christophe Pettus talk
Christophe Pettus slides
pg_hexedit
pageinspect
pg_catcheck

~~~

What did you like or not like? What should we discuss next time? Let us know on YouTube, on social media, or by commenting on our Google doc.

If you would like to share this episode, here's a good link (and thank you!)

~~~

Postgres FM is brought to you by:

Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard

With special thanks to:

Jessie Draws for the amazing artwork

Denne episoden er hentet fra en åpen RSS-feed og er ikke publisert av Podme. Den kan derfor inneholde annonser.

Episoder(182)

pgBackRest

Nik and Michael are joined by David Steele to talk all things pgBackRest. Here are some links to things they mentioned: David Steele https://postgres.fm/people/david-steelepgBackRest https://pgbackres...

3 Jul 1h 13min

autovacuum

Nik and Michael discuss autovacuum, including what it does, and the basics of why and how to tune it. Here are some links to things they mentioned: autovacuum https://www.postgresql.org/docs/current/...

29 Mai 46min

pg_flight_recorder

Nik and Michael are joined by David Ventimiglia to discuss pg_flight_recorder, a new tool he created for monitoring a Postgres database from within. Here are some links to things they mentioned: David...

15 Mai 43min

PgQue

Nik and Michael discuss Nik's new project PgQue, a descendent of Skype's PgQ, for running queue-like workloads in Postgres. Here are some links to things they mentioned: Our first episode on Queues in...

8 Mai 47min

pg_wait_tracer

Nik and Michael are joined by Dmitry Fomin to discuss his new tool pg_wait_tracer, as well as changes that could be made to core to allow wait event tracing with lower overhead, and on managed service...

24 Apr 44min

Schema design checklist

Nik and Michael discuss a list of things to check when designing new schema in Postgres. Here are some links to things they mentioned:Use BIGINT in Postgres (blog post by Ryan Lambert) https://blog.ru...

17 Apr 45min

What’s Missing in Postgres?

Nik and Michael are joined by Bruce Momjian to discuss his new talk "What’s Missing in Postgres?" Here are some links to things they mentioned: Bruce Momjian https://postgres.fm/people/bruce-momjianED...

3 Apr 43min

Long-running transactions

Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues. Here are some links to things they mentioned: transaction_...

27 Mar 48min