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
More from Postgres FM
Nik and Michael are joined by Álvaro Hernández to discuss sharding Postgres with Citus and StackGres, especially the new query router support that has been added very recently.
Nik and Michael are joined by Salma El-Sayed and Kirk Wolak to discuss their in-progress and very ambitious Google Summer of Code project around adding Btree Merge support to Postgres.
Nik and Michael are joined by Sai Srirampur to discuss ClickHouse's new managed Postgres service.
Nik and Michael discuss hot_standby_feedback — what it controls, whether and when read replicas should be changed to on, and other settings you can change to help too.
Nik and Michael are joined by Shaun Thomas to discuss estimating work_mem, memory management in general, and writing an extension to help.