Companion databases
Listen now
Description
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 
More Episodes
Nikolay and Michael discuss foreign keys in Postgres — what they are, their benefits, their overhead, some edge cases to be aware of, some improvements coming, and whether or not they generally recommend using them. Here are some links to things they mentioned: Foreign keys (docs)...
Published 06/21/24
Published 06/21/24
Nikolay is joined by Mat Arye and John Pruitt, from Timescale, to discuss their new extension pgvectorscale and high-performance vector search in Postgres more generally. Main...
Published 06/14/24