# turbopuffer Page: https://stenobird.com/podcast/postgres-fm-5565051/turbopuffer Text version: https://stenobird.com/podcast/postgres-fm-5565051/turbopuffer.md Podcast: [Postgres FM](https://stenobird.com/podcast/postgres-fm-5565051) Published: 2025-09-12T13:00:00+00:00 Episode link: https://share.transistor.fm/s/140eaa67 Audio file: https://media.transistor.fm/140eaa67/f22058c0.mp3 Processing state: not_requested JSON: https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/turbopuffer Duration seconds: 2976 ## Resource Nik and Michael are joined by Simon Eskildsen from turbopuffer — among other things, they discuss ANN index types, tradeoffs that can make sense for search workloads, and when it can make sense to move search out of Postgres. Here are some links to things they mentioned: Simon Eskildsen https://postgres.fm/people/simon-eskildsen turbopuffer https://turbopuffer.com Use ULID Idempotency Keys (tip 6 in this blog post from Shopify) https://shopify.engineering/building-resilient-payment-systems PostgreSQL 18 Release Candidate 1 https://www.postgresql.org/about/news/postgresql-18-rc-1-released-3130 Understanding DiskANN (blog post by Junaid Ahmed) https://www.tigerdata.com/blog/understanding-diskann SPFresh: Incremental In-Place Update for Billion-Scale Vector Search (paper) https://arxiv.org/abs/2410.14452 Amazon S3 adds new functionality for conditional writes https://aws.amazon.com/about-aws/whats-new/2024/11/amazon-s3-functionality-conditional-writes Amazon S3 Vectors https://aws.amazon.com/s3/features/vectors ~~~ 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 ## Actions - request_transcript: `POST https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/turbopuffer/transcription-requests` — Idempotently request low-priority transcript generation for this episode. - read_markdown: `GET https://stenobird.com/podcast/postgres-fm-5565051/turbopuffer.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.