Devrim Gündüz

The PostgreSQL and its ecosystem are not being just distributed as source code, they are also distributed in various binaries formats -- and RPMs are one of them. This talk will go through the packaging cycle: What do package, how to package, how to maintain the package and its lifetime.

You can write a SELECT statement, but do you know your way around Postgres itself? This session is a fast, live-demo tour built for people who know SQL but are newer to Postgres specifically.

Nobody wakes up one day knowing how to safely back up a Postgres database, plan a version upgrade, or explain why they need a connection pooler. It's usually learned the hard way, mid-incident.

Something's wrong with your Postgres database; a query is stuck, the app is timing out, or it's just "slow" and nobody can say why. This session is the diagnostic toolkit for exactly that moment.

The PostgreSQL and its ecosystem are not being just distributed as source code, they are also distributed in various binaries formats -- and RPMs are one of them.

When you start using PostgreSQL, you start hearing some words: LSN, relfrozenxid, cluster, ctid, cmin, cmax, multixactid, age, datfrozenxid, etc. Have you ever wondered what they are, what they are used for, and how to take care of them?

When you start using PostgreSQL, you start hearing some words: LSN, relfrozenxid, cluster, ctid, cmin, cmax, multixactid, age, datfrozenxid, etc. Have you ever wondered what they are, what they are used for, and how to take care of them?

VACUUM is an essential part of PostgreSQL. In this talk, I will go through it, starting from basics to the internals. Here is the outline: MVCC: The basics Data snapshots VACUUM VACUUM processing FREEZE VACUUM tuning VACUUM FULL

PostgreSQL has in-core replication since 9.0, and evolved a lot since then. This talk will first mention about the history of replication in PostgreSQL, especially the improvements in PostgreSQL 15. I will also talk about the future of replication in PostgreSQL.

PostgreSQL has in-core replication since 9.0, and evolved a lot since then. This talk will first mention about the history of replication in PostgreSQL, followed by internals and finally a demo of setting replication quickly.