{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"When not to use Postgres","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/f36947be\"></iframe>","width":"100%","height":180,"duration":2777,"description":"Nik and Michael discuss when not to use Postgres — specifically use cases where it still makes sense to store data in another system.\n \nHere are some links to things they mentioned:\nJust use Postgres (blog post by Ethan McCue) https://mccue.dev/pages/8-16-24-just-use-postgres\nJust Use Postgres for Everything (blog post by Stephan Schmidt) https://www.amazingcto.com/postgres-for-everything\nReal-time analytics episode https://postgres.fm/episodes/real-time-analytics\nCrunchy Data Joins Snowflake https://www.crunchydata.com/blog/crunchy-data-joins-snowflake\nTwo sizes fit most: PostgreSQL and Clickhouse (blog post by Sid Sijbrandij) https://about.gitlab.com/blog/two-sizes-fit-most-postgresql-and-clickhouse\npg_duckdb episode https://postgres.fm/episodes/pg_duckdb\nCloudberry https://github.com/apache/cloudberry\nTime-series considerations episode https://postgres.fm/episodes/time-series-considerations\nQueues in Postgres episode https://postgres.fm/episodes/queues-in-postgres\nLarge Objects https://www.postgresql.org/docs/current/largeobjects.html \nPGlite https://pglite.dev\nParadeDB https://www.paradedb.com\nZomboDB https://github.com/zombodb/zombodb\nturbopuffer https://turbopuffer.com\nHNSW vs. DiskANN (blog post by Haziqa Sajid) https://www.tigerdata.com/learn/hnsw-vs-diskann\nSPANN: Highly-efficient Billion-scale Approximate Nearest Neighbor Search (paper) https://www.microsoft.com/en-us/research/wp-content/uploads/2021/11/SPANN_finalversion1.pdf\nAmazon S3 Vectors https://aws.amazon.com/s3/features/vectors\nIterative Index Scans added to pgvector in 0.8.0 https://github.com/pgvector/pgvector/issues/678\nS3 FDW from Supabase https://github.com/supabase/wrappers/tree/main/wrappers/src/fdw/s3_fdw\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 produced by:\nMichael Christofides, founder of pgMustard\nNikolay Samokhvalov, founder of Postgres.ai\n\nWith...","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}