Introduction to PostgreSQL Performance Tuning
Jim has more than 20 years of experience developing data intensive applications and infrastructure. Prior to joining OpenSCG, Jim was CEO at StormDB, a Postgres-XC scalable public cloud solution. While at StormDB, Jim envisioned the offering and was responsible for all product development. Prior to StormDB, Jim was chief architect at EnterpriseDB, leading the firm’s technology direction, including its early cloud offerings and other product lines. Jim also very active in the PostgreSQL community, co-founding both the New York and Philadelphia PostgreSQL Meetup groups, co-organizing the largest PostgreSQL conferences, and serving on the Board of the PostgreSQL Foundation. Jim also speaks regularly at PostgreSQL and other open sources conferences.
No video of the event yet, sorry!
Out of the box, PostgreSQL is configured to run on very small systems like a Raspberry Pi, but people do not run large scale enterprise applications on a Raspberry Pi. There are many knobs and switches to tune PostgreSQL for your workload, but which ones make a difference. In this talk, we will discuss those knobs and switches on the operating system and the postgresql.conf file that affects performance. We will also dig into tuning a query and discuss PostgreSQL explain plans and give you the base line tools necessary to start tuning your application on PostgreSQL.
- 50 min
- South Africa 2017