Work with PostgreSQL

Work with PostgreSQL

Author: Yu. Vasiliev

Format: pdf

Size: 2MB

Downloaded: 106

Download book PDF

Read Online

PostgreSQL is an incredibly powerful and flexible DBMS; it has similar functionality and syntax with another popular DBMS, MySQL, but its capabilities are much wider. For example, it is able to process data more than MySQL, supports the creation of its own data types, storage of multidimensional arrays, JSON indexing, and much more. This book will help you configure PostgreSQL and use its most useful features.

The book covers the following topics:

  • performance tuning
  • indexes
  • partitioning
  • replication
  • sharding
  • connection multiplexers
  • caching
  • backup and recovery
  • scaling strategies and more