When not to use Postgres
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.
Add to basket failed.
Please try again later
Add to Wish List failed.
Please try again later
Remove from Wish List failed.
Please try again later
Follow podcast failed
Unfollow podcast failed
When not to use Postgres
-
Narrated by:
-
By:
About this listen
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
No reviews yet
In the spirit of reconciliation, Audible acknowledges the Traditional Custodians of country throughout Australia and their connections to land, sea and community. We pay our respect to their elders past and present and extend that respect to all Aboriginal and Torres Strait Islander peoples today.