High Performance PostgreSQL, Tuning and Optimization Guide

Tuesday 3:20 PM - 4:10 PM

@ Bear

PostgreSQL

50 minutes conference

Intermediate

Tracks:
Operations, Developer

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.


Speakers

Ibrar Ahmed

Ibrar Ahmed (Percona)

Senior Software Engineer

Biography:

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.


Slides



  Download Slides  

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863
  • 8081 Arco Corporate Drive - Suite 330 - Raleigh, NC 27617, USA