How PostgreSQL stores rows

Re:How PostgreSQL stores rows by rtpg on Wednesday February 09, 2022 @09:55PM (#30281910)

For people interested in more details about Postgres internals I cannot recommend https://www.interdb.jp/pg/ enough, an excellent text with lots of details

[ Parent | on HN ]

Re:How PostgreSQL stores rows by ahmedalsudani on Wednesday February 09, 2022 @10:24PM (#30282080)

What a great resource. Thank you for the recommendation!

[ Parent | on HN ]

Re:How PostgreSQL stores rows by guenthert on Thursday February 10, 2022 @12:25PM (#30289512)

Is it though? I mean, isn't the appeal of a relational DBMS that it is a black box to the user and it's the query planner's job to yield an efficient search for a given goal? That job will be easier, if the DBMS developers are free to chose internal representation as needed and aren't bound by earlier disclosed details.

[ Parent | on HN ]

Re:How PostgreSQL stores rows by WGH_ on Thursday February 17, 2022 @02:39AM (#30370490)

> I mean, isn't the appeal of a relational DBMS that it is a black box to the user and it's the query planner's job to yield an efficient search for a given goal?

I wish

[ Parent | on HN ]

Re:How PostgreSQL stores rows by ahmedalsudani on Thursday February 10, 2022 @01:07PM (#30290136)

The book is still great, and some of us like to dig into database internals :)

It's by no means a requirement to use the database

[ Parent | on HN ]

Re:How PostgreSQL stores rows by muh_gradle on Thursday February 10, 2022 @07:13AM (#30285083)

Thank you! Sometimes the HN comments really pay off.

[ Parent | on HN ]

Re:How PostgreSQL stores rows by CaptainZapp on Thursday February 10, 2022 @02:45AM (#30283416)

I wish I could +10 you.

I agree, a fantastic resource.

[ Parent | on HN ]