Postgres FM17 Nov 2023

Companion databases

Nikolay and Michael discuss companion databases — when and why you might want to add another database management system to your stack (or not), and some specifics for analytics, timeseries, search, and vectors.

Here are some links to things they mentioned:

Heap were using Postgres + Citus for analytics as of 2022 https://www.heap.io/blog/juggling-state-machines-incident-response-and-data-soup-a-glimpse-into-heaps-engineering-culture
Heap recently moved their core analytics to SingleStore (we only spotted this after recording 🤦‍♂️) https://www.heap.io/blog/heaps-next-generation-data-platform
Posthog moved their analytics from Postgres to Clickhouse https://posthog.com/blog/clickhouse-vs-postgres
Timescale https://www.timescale.com/
Citus https://www.citusdata.com/
Hydra https://www.hydra.so/
Our episode on real-time analytics https://postgres.fm/episodes/real-time-analytics
Our episode on queues https://postgres.fm/episodes/queues-in-postgres
Our episode on logical replication https://postgres.fm/episodes/logical-replication
Full Text Search in PostgreSQL (docs) https://www.postgresql.org/docs/current/textsearch.html
ZomboDB https://www.zombodb.com/
ParadeDB https://www.paradedb.com/
PeerDB https://www.peerdb.io/
RUM indexes https://github.com/postgrespro/rum
Debezium https://debezium.io/
pgmq https://github.com/tembo-io/pgmq
Tembo https://tembo.io/
pgvector vs Pinecone (Supabase blog post) https://supabase.com/blog/pgvector-vs-pinecone
Jepsen analyses https://jepsen.io/analyses

~~~

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

~~~

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

Det här avsnittet är hämtat från ett öppet RSS-flöde och publiceras inte av Podme. Det kan innehålla reklam.

Avsnitt(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 Juli 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 Maj 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 Maj 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 Maj 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 Mars 48min