Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

The Internals of PostgreSQL

interdb.jp

Post reply on HN
Print view View original

1–10 of 43 posts

Re: The Internals of PostgreSQL

#5

Post by 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

Re: The Internals of PostgreSQL

#6

Post by topherjaynes »

codepathfinder wrote: post #4

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

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.

Re: The Internals of PostgreSQL

#7

Post by tasuki »

rrr_oh_man wrote: post #5

> 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 re…

The author is Japanese, cut them some slack.

Re: The Internals of PostgreSQL

#8

Post by xnickb »

tasuki wrote: post #7
rrr_oh_man wrote: post #5

> 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 re…

The author is Japanese, cut them some slack.

Or better yet, offer help

Re: The Internals of PostgreSQL

#9

Post by 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

Re: The Internals of PostgreSQL

#10

Post by paulddraper »

rrr_oh_man wrote: post #5

> 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 re…

What makes the writing horrendous?
Post reply on HN