The Internals of PostgreSQL

[brasetvik]

Also recommend this free book: https://postgrespro.com/community/books/internals

[voctor]

Not related at all but the elephant illustration remind me of the Grand Elephant https://www.lesmachines-nantes.fr/en/discover/the-grand-elep...

[fforflo]

Apart from the usual advice to "start working on a patch to learn the internals," which is not as easy to do because it's a mature product and most of the low-hanging fruits have been reaped, I'd also suggest checking the extensions shipped with the main source tree under $top/contrib. Each one is self-contained and usually works with a subset of the internals. Some good ones: pageinspect, pg_buffercache, pg_prewarm, pg_statstatements, pg_walinspect

[HackerThemAll]

This is an old, but great and regularly updated, source of information about this great RDBMS. A lot of knowledge is accumulated there.

[codepathfinder]

Thanks for sharing. I have been digging deeper around database internals and looks amazing.

[topherjaynes]

Check out the CMU history of the DB class, Andy Pavlo is an amazing teacher and you really get a feel for DBs https://www.youtube.com/watch?v=LWS8LEQAUVc&ab_channel=CMUDa... same class from 5 years ago is great because he's like well I can't get in my hotel room so I'll just record from the street https://www.youtube.com/watch?v=SdW5RKUboKc&t=797s&ab_channe.... Tons of good videos to go through on their youtube channel.

[nimish]

The worst part of Postgres (and linux) is the awful mailing list driven development process. I have patches to Postgres that I'd rather just keep porting up every version than to try to figure out how to make Outlook work with a 1980s process.

The internals themselves are quite nicely engineered as you'd expect

[immibis]

You are unable to send a message with an attachment? Or what's the problem specifically?

[felideon]

> how to make Outlook work

Well that’s your first problem. Unless you’re using corporate email?

[fforflo]

Parent probably means that email clients don't send the attachments (patches) with the appropriate content type (i.e. text/x-patch or text/x-diff) but use application/octet-stream.

[tracker1]

OT: Ug the text contrast is really hard to read here.

[rrr_oh_man]

> Transaction logs are an essential part of databases because they ensure that no data is lost even when a system failure occurs. They are a history log of all changes and actions in a database system. This ensures that no data is lost due to failures, such as a power failure or a server crash. The log contains sufficient information about each transaction that has already been executed, so the database server can recover the database cluster by replaying the changes and actions in the transaction log in the event of a server crash.

The writing is horrendous

[tasuki]

The author is Japanese, cut them some slack.

[datadrivenangel]

It's a little clipped, but very straightforward and easy to follow. Not horrendous.

[skotobaza]

How would you rephrase it? I'm also a non-native English speaker, and the bit you provided sounds very easy to understand because of how it's phrased. There are minor redundancies, but that's all I noticed...

[paulddraper]

What makes the writing horrendous?

[gpvos]

A bit on the wordy side, but better than the average documentation.