Tune PostgreSQL for Read/Write Scalability.
Presented by:
Ibrar Ahmed
Ibrar Ahmed, Principal Engineer at pgEdge, brings 25 years of experience in software design and open-source development, particularly PostgreSQL. With a strong background in system-level embedded development, Ibrar has made impactful contributions during his tenure at companies like EnterpriseDB, Percona, and Bitnine. Since 2006, he's been instrumental in enhancing PostgreSQL's core engine, driving performance improvements, and refining essential modules.
His expertise spans MySQL, Oracle, and NoSQL solutions like MongoDB and Hadoop, alongside tools like Hive, HBase, and Spark. A prolific author and blogger, Ibrar shares deep insights into PostgreSQL with several authoritative books. Over the past year, he’s delivered over fifteen talks worldwide at PostgreSQL conferences, further cementing his reputation. His dedication to advancing data management technology continues to shape
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 is hard 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.
- Date:
- 2022 April 8 13:10 PDT
- Duration:
- 50 min
- Room:
- Winchester
- Conference:
- Silicon Valley 2022
- Language:
- Track:
- Dev
- Difficulty:
- Easy