PostgreSQL for DBA Volume 1: Structure and Administration (Paperback) (ISBN-13: 9781791794125)

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.

Author: Federico Campoli
ISBN-10: 1791794122
ISBN-13: 9781791794125
Publisher: Independently Published
Language: English
Published: 01/19/2019
Pages: 224
Format: Paperback
Weight: 0.80lbs
Size: 9.61h x 6.69w x 0.47d