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