Presented by:

A2d817f888831b27bd69846263c87910

Stephen Frost

Crunchy Data Solutions, Inc.

Stephen Frost is the Chief Technology Officer for Crunchy Data Solutions, Inc.

Stephen is a PostgreSQL Committer and Major Contributor, his previous work has included implementing the role system in 8.1 (replacing the previous user/group system), column-level privileges in 8.4 and improvements to PL/pgSQL.

We'll be looking at PostgreSQL configuration options (postgresql.conf) for logging and basic tuning parameters, going over EXPLAIN and EXPLAIN ANALYZE output for select queries (and the auto_explain module), what the EXPLAIN output means in terms of how the query is being executed, and then going over ways to improve the queries, including index creation, rewriting the query to allow PG to use a different plan, and how to tune parameters for specific queries.

Date:
Duration:
50 min
Room:
Conference:
PGConf US 2017
Language:
Track:
Development
Difficulty:
Medium