PostgreSQL Leftovers
-
PostgreSQL compile times
The arithmetic here is unsurprising up to a point. This machine has 12 CPU cores, so you get speedups until around -j12. But it’s notable that the gains level off at 8. It could be because there are 8 “performance” cores and 4 “efficiency” cores, and the efficiency cores aren’t that helpful for this? Or maybe because there is just not that much more parallelism to be had in the build.
-
PGCloud Conference London: Call for Papers is Now Open!
The Call for Papers is now open for PGCloud Conference London! Taking place in London on 10th August 2023.
We are looking for proposals in English on any topic relating to PostgreSQL and how to optimize, manage, and scale it in a cloud environment. Talk submissions are welcome from a wide variety of PostgreSQL users, from app developers, DBAs, operations engineers, decision makers, and PostgreSQL contributors.
-
pg_dumpbinary v2.11 released
pg_dumpbinarydumps a PostgreSQL database to a binary format. The resulting dump must be restored usingpg_restorebinary, which is provided.pg_dumpbinary 2.11 was released today, it fixes a major issue at restore time.