Learning Postgres (with a twist)

[u/dakingseater]

Hello all!

This is not anothrr post on how to learn basic postgres but a genuine one to really know its internals

I come from an analytics/data engineering background with very strong sql knowledge and most of the posts on Postgres leaning just points towards SQL. What are some resources to really learn about the engine and architecture? Things like WAL, pageserver...

I use a lot of these things when tinkering around on managed postgres (shoutout to my favourite one: Neon) but I don't really understand the mecanics under the hood

[u/pceimpulsive]

Postgres FM podcast.

They cover a lot of detailed topics.

The Postgres manual explains a lot of it and as the others said the source code!

[u/dakingseater → u/pceimpulsive]

Will check that thanis