Postgres Architecture | Saurabh Thakur

saurabhthakur.dev · 1 words · saved by 1 readers

I was very curious about Postgres and it's functioning since a long time and I always wanted to go into details and since I am doing that now, I thought of making some notes. I find these notes to be of fair quality which can be added as an article, so that's what I am doing. I hope you learn something from this. In this article I am mostly discussing about some components of the Postgres DB engine that are always running behind the scenes which we never get to understand. It's abstracted out so well that sometimes companies scale their Postgres instances, without even tweaking any of the parameters. Everything in Postgres works on append only model, meaning every action is added as a new tuple in the Write Ahead Logs (WAL). WAL is an important component in Postgres. I hope to write more about it in upcoming articles. 💡 Pros of using threads The cache hit ratio on the TLB (Translation Lookaside Buffer) will be better (because memory is shared among multiple threads) Now let's discuss

posts/postgres-architecture

Postgres Architecture | Saurabh Thakur

related reading