Episode 157
When not to use Postgres
Postgres FM · Nikolay Samokhvalov and Michael Christofides
September 5, 202546m 17s
Audio is streamed directly from the publisher (media.transistor.fm) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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
Topics
PostgresPostgreSQLDatabasesSQLtechnology