Robert Treat

Ask anything about the PostgreSQL Community. A number of folks involved in the PostgreSQL community regularly attend SCaLE and make themselves available for questions.

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 world's tech unicorns come to a stop because of a possible overflow problem. In this talk I'll talk about the nature of the problem, why we still see it today, and cover many of the various options to work your way through a pending int overflow. I also talk about some of the more advanced work we did to make sure our bases were covered, and walk through techniques you can use to keep from hitting the wall.

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

While no one is against finding and fixing issues before deploying to production, relying on traditional testing methods in the age of data-intensive, internet scale software has proven to be incomplete. This talk touches on common methods including real-world examples of odd edge cases with both testing and monitoring and explains why these will never provide a complete solution.

Postgres 12 was released in late 2019. In this talk well cover new features, enhancements, and upgrade strategies for this new version of Postgres.

Postgres 10 added a new form of replication; logical replication; into its wide array of replication and failover options. In this talk, we'll discuss what logical replication is, differences between Postgres 10 and 11, how it differs from other replication options, and why you should, or maybe shouldn't, use it. We'll then walk through a live demo of setting up logical replication between two servers and do live experimentation with our cluster based on audience participation. Want to know how easy it is to break replication? There's no better way to find out!

Beginning in 8.1, PostgreSQL has offered table partitioning, allowing you to split data across different physical segments for significant performance improvements. While the feature is simple to get into, managing large table partition setups can prove tricky to the beginner. In this tutorial we will discuss many of the insider tricks that are used in today's largest setups and talk about what the documentation leaves out.