List of videos

In this presentation, Pierre gives an introduction to what multi-tenant databases are, how they can be implemented, and how they can come back haunt you.

The idea of predicting how the database is going to behave under certain conditions is very attractive. In this talk, Dmitry goes beyond science fiction to discuss possible approaches for modelling, taking a simplified PostgreSQL index under a load as an example -- and tries to simulate and verify the resulting IO profile.

Bertrand Drouvot describes one of the Postgres 16 new features related to logical decoding: Logical decoding on standby. Includes a live demo.

Postgres rules ok! What next? What features do we need? What will the future look like? How will we get there? What challenges will we face?

Big events, like PGConf EU, allow participants to interact with a large group of top professionals from all over the world and choose from a variety of presentations. However, not everybody can afford long-distance travel and several days off work. Enter PGDays—local one-day conferences where Postgres users, developers and enthusiasts can gather close to home. PGDays are vital for PostgreSQL community development and growth as they provide smaller, more intimate opportunities for people to network and to learn from each other. What if your city does not run a PGDay, but you really want one? What does it take to start a new PGDay? Are you the right person to start it? Can you do so alone? What’s in it for you? How can you help if you don’t want to drive the whole thing? Are there less time-consuming ways to help? What if your city does not run a PGDay, but you really want one? How can you encourage a new PGDay? Are you the right person to lead one? How can you build a great team? How can you help without assuming a leading role? What’s in it for you? In this session, we will share our experiences as part of the operations teams that organized the first PGDay Chicago and the first PgDay San Francisco, including successes you can copy, and hurdles to watch out for.

Have you ever tried your hand at Advent of Code, the annual online coding challenge that takes place during the holiday season? It's a fun and challenging way to test your coding skills and get into the holiday spirit. But what if we told you that there were ways to solve the problems using only SQL? In this talk, I will explain my experience trying to solve the advent of Code challenges with SQL only (Postgres flavor). My rules, what I learned, the hard parts, the easy parts, my tips, and my tricks (should you want to try it yourself) but overall how much it enlightened my use of Postgres and SQL. Whether you're a seasoned Advent of Code veteran or a newcomer to the challenge, whether your SQL skills are basic or advanced, I hope that attendees will come away with a newfound appreciation for the power and flexibility of SQL, as well as some ideas for how to incorporate them into their own coding practices.

In this talk, I'll explain how autovacuum decides which tables to vacuum and analyze and when to perform these operations, with an emphasis on how these algorithms can go wrong. Then, I'll discuss troubleshooting steps that you can take on your system to determine why autovacuum is not performing as expected, as well as how you can fix the problems you might discover.

PostgreSQL provides great support for JSON objects and every developer working with this data type should learn how to take advantage of it. Instead of going through the documentation on how to use JSON in PostgreSQL, in this talk we will use a case study to learn by example. We will also complement the usage of JSON by introducing other data types such as ARRAY. We will also review some design decisions to turn JSON objects into columns and vice versa when it's convenient. This talk will help you to axe the archaic Entity-Attribute-Value (EAV) pattern from your database. We will see how to combine the power of a relational model, enhanced with the flexibility of the schema freedom provided by JSON. Not many database engines can provide the level of synergy that PostgreSQL provides.

In modern applications, geographical and spatial data are rapidly gaining importance. This leads to the requirement to efficiently store and process such data within a database. The PostgreSQL extension PostGIS, is specially designed for handling geographical and spatial data, fulfills this requirement. Combining PostGIS with the pgRouting extension, results in a very powerful routing tool, all within a PostgreSQL database. We now have the ability to process and analyze spatial data, and we can find answers to questions such as "What is the shortest or the fastest route from Point A to Point B?". Both PostGIS and pgRouting are open-source tools released under the GNU General Public License. Maintenance and development has been ensured and driven on by a large community for the past 23 years. These extensions, both can be activated directly within PostgreSQL, making the enhanced DB a highly suitable basis for a variety of applications. In this talk, I will provide a brief introduction to PostGIS and pgRouting, show practical examples from my daily work with geographic data, and we will explore potential use cases for PostGIS and pgRouting.