Craig Kerstiens

Postgres continues to get more and more feature rich. But equally as impressive is the network of extensions that are growing around Postgres. With the rich extension APIs you can now add advanced functionality to Postgres without having to fork the codebase or wait for the main PostgreSQL release cycle.

This is a late addition to the schedule.

Postgres continues to get more and more feature rich. But equally as impressive is the network of extensions that are growing around Postgres. With the rich extension APIs you can now add advanced functionality to Postgres without having to fork the codebase or wait for the main PostgreSQL release cycle. In this talk we'll cover some of the basics of what an extension is and then take a tour through a variety of Postgres extensions including:

pgstatstatments PostGIS HyperLogLog and TopN Timescale pg_partman Citus Foreign data wrappers which are their own whole class

To many developers the database is a black box. You expect to be able to put data into your database, have it to stay there, and get it out when you query it... hopefully in a performant manner. When its not performant enough the two options are usually add some indices or throw some hardware at it. We'll walk through a bit of a clearer guide of how you can understand how database is doing from a 30,000 foot perspective as well as analyze specific problematic queries and how to tune them. In particular we'll cover:

• Postgres Caching
• Postgres Indexing
• Explain Plans
• Extensions
• More

Postgres has long been known as a stable database product that reliably stores your data. However, in recent years it has picked up many features, allowing it to become a much sexier database.

We'll cover a whirlwind of Postgres features, which highlight why you should consider it for your next project. These include:

• Datatypes
• Using other languages within Postgres
• Extensions including NoSQL inside your SQL database
• Accessing your non-Postgres data (Redis, Oracle, MySQL) from within Postgres
• Window Functions