{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Companion databases","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/72c91d81\"></iframe>","width":"100%","height":180,"duration":2758,"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. \n \nHere are some links to things they mentioned:\nHeap 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 \nHeap recently moved their core analytics to SingleStore (we only spotted this after recording 🤦‍♂️) https://www.heap.io/blog/heaps-next-generation-data-platform \nPosthog moved their analytics from Postgres to Clickhouse https://posthog.com/blog/clickhouse-vs-postgres \nTimescale https://www.timescale.com/ \nCitus https://www.citusdata.com/ \nHydra https://www.hydra.so/ \nOur episode on real-time analytics https://postgres.fm/episodes/real-time-analytics \nOur episode on queues https://postgres.fm/episodes/queues-in-postgres \nOur episode on logical replication https://postgres.fm/episodes/logical-replication \nFull Text Search in PostgreSQL (docs) https://www.postgresql.org/docs/current/textsearch.html \nZomboDB https://www.zombodb.com/ \nParadeDB https://www.paradedb.com/ \nPeerDB https://www.peerdb.io/ \nRUM indexes https://github.com/postgrespro/rum \nDebezium https://debezium.io/ \npgmq https://github.com/tembo-io/pgmq \nTembo https://tembo.io/ \npgvector vs Pinecone (Supabase blog post) https://supabase.com/blog/pgvector-vs-pinecone \nJepsen analyses https://jepsen.io/analyses \n\n~~~\nWhat 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!\n\n~~~\nPostgres FM is brought to you by:\nNikolay Samokhvalov, founder of Postgres.ai\nMichael Christofides, founder of pgMustard\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}