Internals of PostgreSQL

#1

Post by billwashere » Sun, Jan 20, 2019, 1:57 AM UTC

Internals of PostgreSQL
interdb.jp

Re: Internals of PostgreSQL

#2

Post by jsjohnst » Sun, Jan 20, 2019, 6:32 AM UTC

Does anyone know if something like this exists for other popular DBs?

Re: Internals of PostgreSQL

#3

Post by aportnoy » Sun, Jan 20, 2019, 7:33 AM UTC

jsjohnst wrote: post #2

Does anyone know if something like this exists for other popular DBs?

This only covers one feature of SQLite, but I recommend it nonetheless: https://www.sqlite.org/queryplanner.html

Re: Internals of PostgreSQL

#4

Post by codetrotter » Sun, Jan 20, 2019, 7:38 AM UTC

Following the link to the blog of the author I found a blog post titled “postgres cluster management system in GoCardless”

http://www.interdb.jp/blog/pgsql/pg_pacemaker_01/

Which in turn lead me to

https://github.com/gocardless/our-postgresql-setup

And in turn to a fifteen minute talk titled “Zero-downtime Postgres upgrades”

https://www.youtube.com/watch?v=SAkNBiZzEX8

Which was interesting and informative IMO.

After watching that one I was lead further via the YouTube suggested videos to a 45 minute talk titled “Tuning PostgreSQL for High Write Loads”

https://www.youtube.com/watch?v=xrMbzHdPLKM

Which I liked a lot as well.

I think anyone who came here because they are interested in the subject of the OP link might be interested in watching these videos.

Though disclaimer of course: These videos told me things I didn’t know about scaling PostgreSQL, because there is a lot I don’t know about that. But if you already know a lot about that then of course these videos might not be so interesting to you.

Re: Internals of PostgreSQL

#5

Post by asaddhamani » Sun, Jan 20, 2019, 7:54 AM UTC

codetrotter wrote: post #4

Following the link to the blog of the author I found a blog post titled “postgres cluster management system in GoCardless” http://www.interdb.jp/blog/pgsql/pg_pacemaker_01/ Which in turn lead me to https://github.com/gocardless/our-postgresql-setup And in turn to a fifteen minute talk titled “Zero-downtime Postgres upgrades” https://www.youtube.com/watch?v=SAkNBiZzEX8 Which was interesting and informative IMO. After…

Interesting stuff. If anyone wants to make a PR to add this stuff to https://github.com/dhamaniasad/awesome-postgres I'll be happy to accept.

Re: Internals of PostgreSQL

#6

Post by chris_wot » Sun, Jan 20, 2019, 8:17 AM UTC

This is the thing I love about PostgreSQL, you can find out everything about the database. Oracle is ridiculous - they have something of the range of over a thousand hidden parameters, query tuning their CBO is somewhat of a black art and can change between point releases, and leads to articles like the following:

http://www.dba-oracle.com/art_so_undoc_parms_p2.htm

PostgreSQL, however, has none of these limitations.

Re: Internals of PostgreSQL

#7

Post by chris_wot » Sun, Jan 20, 2019, 8:17 AM UTC

jsjohnst wrote: post #2

Does anyone know if something like this exists for other popular DBs?

The Inside SQL Server series by Microsoft Press is pretty impressive.

Re: Internals of PostgreSQL

#8

Post by forinti » Sun, Jan 20, 2019, 9:39 AM UTC

chris_wot wrote: post #6

This is the thing I love about PostgreSQL, you can find out everything about the database. Oracle is ridiculous - they have something of the range of over a thousand hidden parameters, query tuning their CBO is somewhat of a black art and can change between point releases, and leads to articles like the following: http://www.dba-oracle.com/art_so_undoc_parms_p2.htm PostgreSQL, however, has none of these limitations.

Oracle also has serious quality issues. The last patch set I applied had the wrong binaries for Oracle Text. With what they charge, you wouldn't expect that. I've never had such a thing happen with my Postgresql instances. I just don't see how to justify starting out with Oracle today.

Re: Internals of PostgreSQL

#9

Post by billwashere » Sun, Jan 20, 2019, 10:45 AM UTC

chris_wot wrote: post #6

This is the thing I love about PostgreSQL, you can find out everything about the database. Oracle is ridiculous - they have something of the range of over a thousand hidden parameters, query tuning their CBO is somewhat of a black art and can change between point releases, and leads to articles like the following: http://www.dba-oracle.com/art_so_undoc_parms_p2.htm PostgreSQL, however, has none of these limitations.

Your comment reminded me of oraguy comment about oracle db

[1] https://news.ycombinator.com/item?id=18442637

Re: Internals of PostgreSQL

#10

Post by billwashere » Sun, Jan 20, 2019, 10:55 AM UTC

chris_wot wrote: post #7

jsjohnst wrote: post #2

Does anyone know if something like this exists for other popular DBs?

The Inside SQL Server series by Microsoft Press is pretty impressive.

This series is now called Microsoft SQL Server Internals [1]. You can get the latest version - Microsoft SQL Server 2012 Internals (Developer Reference)- from Amazon [2].

[1] https://www.sqlserverinternals.com/publications/

[2] https://www.amazon.com/gp/product/0735658560/ref=as_li_tl?ie...