# When not to use Postgres

Page: https://stenobird.com/podcast/postgres-fm-5565051/when-not-to-use-postgres
Text version: https://stenobird.com/podcast/postgres-fm-5565051/when-not-to-use-postgres.md
Podcast: [Postgres FM](https://stenobird.com/podcast/postgres-fm-5565051)
Published: 2025-09-05T13:00:00+00:00
Episode link: https://share.transistor.fm/s/f36947be
Audio file: https://media.transistor.fm/f36947be/24445e34.mp3
Processing state: not_requested
JSON: https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/when-not-to-use-postgres
Duration seconds: 2777

## Resource

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 YouT…

## Actions

- request_transcript: `POST https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/when-not-to-use-postgres/transcription-requests` — Idempotently request low-priority transcript generation for this episode.
- read_markdown: `GET https://stenobird.com/podcast/postgres-fm-5565051/when-not-to-use-postgres.md` — Read the agent-friendly Markdown representation of this episode resource.

A page view does not enqueue transcription. Agents should invoke `request_transcript` explicitly when they need this episode processed.

## Transcript

Full transcripts are not published on public pages unless there is a clear rights basis.