# Schema design checklist

Page: https://stenobird.com/podcast/postgres-fm-5565051/schema-design-checklist
Text version: https://stenobird.com/podcast/postgres-fm-5565051/schema-design-checklist.md
Podcast: [Postgres FM](https://stenobird.com/podcast/postgres-fm-5565051)
Published: 2026-04-17T13:00:00+00:00
Episode link: https://share.transistor.fm/s/395dd845
Audio file: https://media.transistor.fm/395dd845/86adb238.mp3
Processing state: not_requested
JSON: https://stenobird.com/v1/public/podcasts/postgres-fm-5565051/episodes/schema-design-checklist
Duration seconds: 2729

## Resource

Nik and Michael discuss a list of things to check when designing new schema in Postgres. Here are some links to things they mentioned: Use BIGINT in Postgres (blog post by Ryan Lambert) https://blog.rustprooflabs.com/2021/06/postgres-bigint-by-default Postgres 18 and UUIDv7 (blog post by Gwen Shapira) https://www.thenile.dev/blog/uuidv7 How to use UUID (how-to guide by Nik) https://postgres.ai/docs/postgres-howtos/schema-design/data-types/how-to-use-uuid Our episode on constraints https://postgres.fm/episodes/constraints Our episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown MultiXact member space exhaustion episode (with Metronome) https://postgres.fm/episodes/multixact-member-space-exhaustion Our Column Tetris episode https://postgres.fm/episodes/column-tetris Saving Space Basically for Free (blog post by James Coleman from Braintree) https://medium.com/paypal-tech/postgresql-at-scale-saving-space-basically-for-free-d94483d9ed9a Over-indexing episode https://postgres.fm/episodes/over-indexing Under-indexing episode https://postgres.fm/episodes/under-indexing Gadget's use of Postgres https://postgres.fm/episodes/gadgets-use-of-postgres Partitioning episode https://postgres.fm/episodes/partitioning RLS vs performance episode https://postgres.fm/episodes/rls-vs-performance ~~~ 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/schema-design-checklist/transcription-requests` — Idempotently request low-priority transcript generation for this episode.
- read_markdown: `GET https://stenobird.com/podcast/postgres-fm-5565051/schema-design-checklist.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.