By design, the out of the box configuration for PostgreSQL is defined to be a "Jack of All Trades, Master of None". The default configuration for PostgreSQL is fairly painstakingly chosen to ensure that it will run on every environment it is installed, meeting the lowest common denominator resources across most platforms.
As a database grows and scales up from a proof of concept to a full-fledged production instance, there are always a variety of growing pains that database administrators and systems administrators will run into.
Learn the top 5 settings to tune once an install of PostgreSQL is completed to optimize performance.
With the recent release of PostgreSQL 12, pgBackRest also received a number of updates and changes to take advantage of the latest features of Postgres.