Robert Treat

There is a lot of excitement around the new REPACK command in Postgres 19, but how much of that is hype rather than something that will actually help? In this talk we will walk through a brief history of bloat management in Postgres, covering commands like CLUSTER and the evolution of VACUUM FULL, and discuss how tools like pg_repack and pg_squeeze came to be, including why we even have two...

PostgreSQL is often thought of as "The Database for DBAs", but what more and more developers are finding out is that what makes Postgres "The Worlds Most Advanced Open Source Database" is its wide array of features, many of which are really geared towards users who want to build applications on top of Postgres.

Amazon has a long history with PostgreSQL, whether it be internal company adoption or the many AWS services built around it. In this session, Robert Treat looks back across Amazon's journey with PostgreSQL, from its large-scale migration from Oracle to the creation of Amazon RDS for PostgreSQL.

PostgreSQL is often thought of as “The Database for DBAs”, but what more and more developers are finding out is that what makes Postgres “The Worlds Most Advanced Open Source Database” is its wide array of features, many of which are really geared towards users who want to build applications on...

Follow along as we deep dive into a real-world transaction wraparound incident, discuss recent Postgres innovations, and explore features like index de-duplication and autovacuum enhancements designed to help eliminate the problems.

We have all heard about Postgres vacuum horror stories and tales of transaction wraparound disasters. Even if you've never been through one yourself, you may be concerned that you might someday experience it, or may know people who have avoided Postgres altogether because of it.

We have all heard about Postgres vacuum horror stories and tales of transaction wraparound disasters. Even if you've never been through one yourself, you may be concerned that you might someday experience it, or may know people who have avoided Postgres altogether because of it.

You're a DBA or Developer and you've been hearing more and more about Postgres and maybe even used it a few times, but aren't sure where to get started to learn more. In this session, I'll teach you the basics of how Postgres works using a copy of the Stack Overflow database ported to Postgres.

It's 2021 and we are still dealing with integer overflow. Just a few months ago I came within 24 hours of watching one of the worlds tech unicorns come to a stop due to possible int overflow problems.

It's 2021 and we're still dealing with integer overflow. Just a few months ago I came within 24 hours of watching one of the worlds tech unicorns come to a stop due because of a possible overflow problem.

PostgreSQL is often thought of as "The Database for DBAs", but what more and more developers are finding out is that what makes Postgres "The Worlds Most Advanced Open Source Database" is its wide array of features, many of which are really geared towards developers building applications on top of...

It is hard to believe, but plpgsql used to be a thing. Now lost in all the hype of REST APIs and JSON wizardry, the idea of doing server-side database functions gives most people the shivers.

Postgres 10 added a new form of replication; logical replication; into the wide array of replication and failover options available within the Postgres ecosphere.