from Hacker News

Internals of PostgreSQL

by billwashere on 1/20/19, 1:57 AM with 25 comments

  • by codetrotter on 1/20/19, 7:38 AM

    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.

  • by chris_wot on 1/20/19, 8:17 AM

    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.

  • by vordoo on 1/20/19, 6:52 PM

    Reminded me that "Postgres is easy to install, administer, maintain, and use... with just a little bit of orientation. This is that orientation."

    Christophe Pettus: PostgreSQL Proficiency for Python People - PyCon 2014. https://www.youtube.com/watch?v=0uCxLCmzaG4

  • by jsjohnst on 1/20/19, 6:32 AM

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

  • by onezeronine2 on 1/20/19, 12:21 PM

    As a person who have started in SQL server, I really like the succinct clarity of Postgresql functions and its lightweight installation on the server. Thanks for sharing, this could really help me in the future.

  • by speg on 1/20/19, 1:22 PM

    Aside: do you still need to use a cache service when using Postgres? Our Django web app forgoes any caching because “Postgres is fast enough” and “has its own cache”.

  • by mohsinhijazee on 1/20/19, 11:39 AM

    Thank you for posting. Really great resource.

  • by woile on 1/20/19, 3:10 PM

    Awesome source, does anyone know how to convert it into a mobi? I'd like to send it to my kindle