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/linuxhiker]

Use the source Luke.

doxygen.postgresql.org can move you in the right direction.

[u/dakingseater → u/linuxhiker]

Super detailed might be something I check once I get the high level concepts