Tune PostgreSQL for Read/Write Scalability.

PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Nowadays, production systems have quite expensive machines, which require extra configuration for PostgreSQL. PostgreSQL provides extensive configuration parameters to configure it according to the available hardware. Sometimes it takes work to configure PostgreSQL to get the maximum performance output because it depends on the hardware, workload, and queries. Most of the time, people configure PostgreSQL according to hardware and don’t consider the workload and type of queries. Sometimes a database is write-intensive, sometimes read-intensive, and occasionally read and write-intensive. In all these three cases, there’s a different set of configurations. In this talk, users will see how to configure PostgreSQL for a Read/Write/Read-Write intensive load. This talk will explain every important configuration parameter with real-time examples.