Schema design checklist
Nik and Michael discuss a list of things to check when designing new schema in Postgres.
Here are some links to things they mentioned:
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!
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