PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system with least resources. PostgreSQL does not give optimum performance on high permanence machine because it is not using the all available resource. PostgreSQL provides a system you can tune your database according to your workload and machine specification. Other than PostgreSQL we can also tune our Linux box so that database load can work optimally. Here we learn how to tune PostgreSQL and will see the results of that tuning, We will also touch some of the Linux kernel parameters tuning.
Ibrar Ahmed is a Senior Software Engineer in Percona. Prior to coming to open source development, he had vast experience in software design and development. The main focus was in the system level embedded development, which ranges from 8bit microprobes for low power system to embedded linux for latest processor.
After joining the Enterprise PostgreSQL's company in 2006 he started his career in open source development specifically in PostgreSQL. Has contributed to the PostgreSQL community as well as other open source communities. The contribution are from main performance feature enhancement to PostgreSQL's modules. In database field he has experience in other well-known databases MySQL, Oracle, and NoSQL databases such as MongoDB and Hadoop. The experience does not limited to core database but with the tools related to databases like Hive, Hbase and Spark. He also worked on integrating these tools with PostgreSQL.