Federico Campoli

PostgreSQL for DBA Volume 1 Federico Campoli

This is the first volume of a book series covering PostgreSQL from the database administration point of view. The book covers PostgreSQL 11 on Linux analysing the install procedure either from sourceand with packages on Debian and RPM based systems. A good part of the book explains the logical organisation and the physical structure in order to givethe reader a good starting point to understand the PostgreSQL internals. Logical backup and restore with pg_dump are also analysed and performance tips for speeding up a disaster recovery are given. The book also explain how PostgreSQL executes a query, the maintenance and the internal statistics in order to give the database administrators the know how for keeping PostgreSQL running efficiently at all time.