Stephen Frost

We'll be looking at PostgreSQL configuration options (postgresql.conf) for logging and basic tuning parameters, how to monitor which queries are taking the most time using pg_stat_statements, 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.

A panel of PostgreSQL community members is here to answer any questions about any aspect of the project.

PostgreSQL supports a number of different authentication mechanisms and while many of them are quite simple and easy to use, the enterprise-level authentication systems require setup beyond PostgreSQL and a deeper understanding of how authentication works.

Ever work with advanced SQL constructs such as Common Table Expressions (CTEs)?åÊ What about window functions, or LATERAL? Come learn about advanced SQL capabilities supported in your favorite open source RDBMS- PostgreSQL.

We'll cover the basics of PostgreSQL administration, defining 'cluster', 'database', 'schema' and 'tablespace' in PostgreSQL, when to use which, how to authenticate to PostgreSQL as a unix user or over a network, what authentication systems PostgreSQL can integrate with, setting up new users and groups (aka roles) in PostgreSQL, how to control access to PostgreSQL objects (including setting up default permissions for certain types of objects), addressing storage needs as your database grows by using tablespaces and a crash-course of how to tune PostgreSQL for your brand new database.