Henrietta Dombrovskaya

Henrietta (Hettie) Dombrovskaya is a database researcher and practitioner with over 40 years of academic and industrial experience. At present she is

– Database Architect at DRW Holdings in Chicago, IL
– Local Organizer of the Chicago PostgreSQL User Group
– Active community member, a frequent speaker at the PostgreSQL Conferences
- Prairie Postgres NFP President
-- A researcher focused on developing efficient interactions between applications and databases and implementation of temporal data
–– An author of the PostgreSQL Query Optimization book


What is your Twitter handle?:

@HettieDombr


Session

09-08
17:00
25min
PostgreSQL: Tuning parameters or Tuning Queries?
Henrietta Dombrovskaya

When it comes to database performance tuning, most PostgreSQL practitioners focus on optimizing configuration parameters. Although some parameter tuning can indeed improve the database performance, we are usually talking about 10%, 20%, and in rare cases, up to 50% performance improvement. That might sound like impressive numbers, but individual query optimization routinely makes queries run several times faster, in some cases, ten or more times faster!

Room A