Sharding | Postgres.FM 058 |
[ 🇬🇧_🇺🇸 We recorded late this week, so the manually edited subtitles are a bit delayed]
Nikolay and Michael discuss sharding Postgres — what it means, why and when it's needed, and the available options right now.
Here are some links to some things they mentioned:
PGSQL Friday monthly blogging event https://www.pgsqlphriday.com/
Did “sharding” come from Ultima Online? https://news.ycombinator.com/item?id=...
Our episode on partitioning: https://postgres.fm/episodes/partitio...
Vitess https://vitess.io/
Citus https://www.citusdata.com/
Lessons learned from sharding Postgres (Notion 2021) https://www.notion.so/blog/sharding-p...
The Great Re-shard (Notion 2023) https://www.notion.so/blog/the-great-...
The growing pains of database architecture (Figma 2023) https://www.figma.com/blog/how-figma-...
Timescale multi-node https://docs.timescale.com/self-hoste...
PgCat https://github.com/postgresml/pgcat
SPQR https://github.com/pg-sharding/spqr
PL/Proxy https://plproxy.github.io/
Sharding GitLab by top-level namespace https://about.gitlab.com/handbook/eng...
Loose foreign keys (GitLab) https://docs.gitlab.com/ee/developmen...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.