When not to use Postgres

Nik and Michael discuss when not to use Postgres — specifically use cases where it still makes sense to store data in another system.

Here are some links to things they mentioned:
• Just use Postgres (blog post by Ethan McCue) mccue.dev/pages/8-16-24-just-use-postgres
• Just Use Postgres for Everything (blog post by Stephan Schmidt) amazingcto.com/postgres-for-everything
• Real-time analytics episode postgres.fm/episodes/real-time-analytics
• Crunchy Data Joins Snowflake crunchydata.com/blog/crunchy-data-joins-snowfl…
• Two sizes fit most: PostgreSQL and Clickhouse (blog post by Sid Sijbrandij) about.gitlab.com/blog/two-sizes-fit-most-postg…
• pg_duckdb episode postgres.fm/episodes/pg_duckdb
• Cloudberry github.com/apache/cloudberry
• Time-series considerations episode postgres.fm/episodes/time-series-considerations
• Queues in Postgres episode postgres.fm/episodes/queues-in-postgres
• Large Objects postgresql.org/docs/current/largeobjects.html
• PGlite pglite.dev
• ParadeDB paradedb.com
• ZomboDB github.com/zombodb/zombodb
• turbopuffer turbopuffer.com
• HNSW vs. DiskANN (blog post by Haziqa Sajid) tigerdata.com/learn/hnsw-vs-diskann
• SPANN: Highly-efficient Billion-scale Approximate Nearest Neighbor Search (paper) microsoft.com/en-us/research/wp-content/upload…
• Amazon S3 Vectors aws.amazon.com/s3/features/vectors
• Iterative Index Scans added to pgvector in 0.8.0 github.com/pgvector/pgvector/issues/678
• S3 FDW from Supabase github.com/supabase/wrappers/tree/main/wrapper…

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork