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
Session
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!