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) https://mccue.dev/pages/8-16-24-just-use-postgres
- Just Use Postgres for Everything (blog post by Stephan Schmidt) https://www.amazingcto.com/postgres-for-everything
- Real-time analytics episode https://postgres.fm/episodes/real-time-analytics
- Crunchy Data Joins Snowflake https://www.crunchydata.com/blog/crunchy-data-joins-snowflake
- Two sizes fit most: PostgreSQL and Clickhouse (blog post by Sid Sijbrandij) https://about.gitlab.com/blog/two-sizes-fit-most-postgresql-and-clickhouse
- pg_duckdb episode https://postgres.fm/episodes/pg_duckdb
- Cloudberry https://github.com/apache/cloudberry
- Time-series considerations episode https://postgres.fm/episodes/time-series-considerations
- Queues in Postgres episode https://postgres.fm/episodes/queues-in-postgres
- Large Objects https://www.postgresql.org/docs/current/largeobjects.html
- PGlite https://pglite.dev
- ParadeDB https://www.paradedb.com
- ZomboDB https://github.com/zombodb/zombodb
- turbopuffer https://turbopuffer.com
- HNSW vs. DiskANN (blog post by Haziqa Sajid) https://www.tigerdata.com/learn/hnsw-vs-diskann
- SPANN: Highly-efficient Billion-scale Approximate Nearest Neighbor Search (paper) https://www.microsoft.com/en-us/research/wp-content/uploads/2021/11/SPANN_finalversion1.pdf
- Amazon S3 Vectors https://aws.amazon.com/s3/features/vectors
- Iterative Index Scans added to pgvector in 0.8.0 https://github.com/pgvector/pgvector/issues/678
- S3 FDW from Supabase https://github.com/supabase/wrappers/tree/main/wrappers/src/fdw/s3_fdw
~~~
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 produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With credit to:
- Jessie Draws for the elephant artwork