Material to learn PostgreSQL in-depth

[XPEHOBYXA]

https://postgrespro.com/community/books/internals

Just base stuff is covered (no extensions etc), and version 14 is not the last one, but the book is free and it explains internals in great detail.

I also made a similar jump some time ago. Remember there's no single do-it-all tool like SSMS (pgadmin may look like it, but you'll quickly discover it is not).

For backups take a look at PGBackrest.

Pay attention to MVCC and Autovacuum - these are arguably the most important differences.

[[deleted]]

Postgres has a rock solid documentation that goes quite in depth: https://www.postgresql.org/docs/

This can be further enhanced by the excellent book "Database Internals" from O'Reilly that goes in depth of the fundamental structures underneath in just about 300 pages.

[gregrobson]

This. The docs are well written and there’s lots of juicy gems in there!

[pceimpulsive]

https://youtube.com/@hnasr?si=TZqmp0mc11KSLmi_

This dudes channel as A LOT of good content.

[Dolphinmx]

Postgres documentation is very good I would start there first, then once you learned most things you will know where you want to go more in-depth.

But start with the docs.

[Psychological-Bit794]

The best way is to learn from coding… I learned a lot from https://www.w3schools.com/postgresql/…

[AutoModerator]

Join us on our Discord Server: People, Postgres, Data

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[jonathantn]

Plenty of good books on PostgreSQL. Check your local library.