Episodes
-
Managing your Tuple Graveyard - Chelsea Dole
When making the leap from "running Postgres" to "running Postgres at scale", managing table bloat is a hurdle which many engineers trip over. In this talk, we discuss everything from Postgres internals to application design on the journey to under...
-
Managing your Tuple Graveyard - Chelsea Dole
When making the leap from "running Postgres" to "running Postgres at scale", managing table bloat is a hurdle which many engineers trip over. In this talk, we discuss everything from Postgres internals to application design on the journey to under...
-
Bertrand Drouvot Postgres 16 highlight Logical decoding on standby
Bertrand Drouvot describes one of the Postgres 16 new features related to logical decoding: Logical decoding on standby. Includes a live demo.
-
Dmitry Dolgov Calculating the future how to model PostgreSQL performance
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 loa...
-
Pierre Ducroquet Multi tenant database the good, the bad, the ugly
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.
-
Lightning talks
Claire Giordano: Fighting the Butterflies & giving your first Postgres conference talk Léo Unbekandt: Deploying thousands of PostgreSQL Clusters - High-Level Architecture of a DBaaS Karen Jex: You Don't Need a Database Backup Policy Chris Ellis...
-
Matthias van de Meent PostgreSQL without permanent local data storage
In this talk, Matthias discusses the technical challenges they encountered at Neon while building a disaggregated storage and compute project based on a PostgreSQL fork: the problems that they encountered, the solutions they built for them, and th...
-
Dirk Krautschick Sustainable Database Performance profiling in PostgreSQL
Dirk talks about the PostgreSQL extension PG_PROFILE, including requirements and basic setup. He shows with examples and practical experiences how this can be used for proceeding performance analytics.
-
Valeria Kaplan Elephant in a nutshell Navigating the Postgres community 101
If you are a newcomer to PostgreSQL or want to be more active within the community you need to understand how the community works, what different roles are, where to look for help and who stands behind the “PostgreSQL community”. Valeria's talk co...
-
Valeria Kaplan Elephant in a nutshell Navigating the Postgres community 101
If you are a newcomer to PostgreSQL or want to be more active within the community you need to understand how the community works, what different roles are, where to look for help and who stands behind the “PostgreSQL community”. Valeria's talk co...
-
Dirk Krautschick Sustainable Database Performance profiling in PostgreSQL
Dirk talks about the PostgreSQL extension PG_PROFILE, including requirements and basic setup. He shows with examples and practical experiences how this can be used for proceeding performance analytics.
-
Matthias van de Meent PostgreSQL without permanent local data storage
In this talk, Matthias discusses the technical challenges they encountered at Neon while building a disaggregated storage and compute project based on a PostgreSQL fork: the problems that they encountered, the solutions they built for them, and th...
-
Lightning talks
Claire Giordano: Fighting the Butterflies & giving your first Postgres conference talk Léo Unbekandt: Deploying thousands of PostgreSQL Clusters - High-Level Architecture of a DBaaS Karen Jex: You Don't Need a Database Backup Policy Chris Ellis...
-
Pierre Ducroquet Multi tenant database the good, the bad, the ugly
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.
-
Dmitry Dolgov Calculating the future how to model PostgreSQL performance
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 loa...
-
Bertrand Drouvot Postgres 16 highlight Logical decoding on standby
Bertrand Drouvot describes one of the Postgres 16 new features related to logical decoding: Logical decoding on standby. Includes a live demo.
-
Upgrade Postgres! - Lætitia AVROT
Postgres is stable, too stable, so stable that we sometimes forget that it still needs maintenance. Upgrading Postgres regularly is part of the routine maintenance that most people won't do. That's why we see so many Postgres clusters still in Pos...
-
PostgreSQL and Software Engineers - Henrietta Dombrovskaya
Those who often interact with application developers know how often these developers are upset with us, with PostgreSQL, and with databases in general. In addition to the usual complaints that "databases are slow" and "database developers are slow...
-
Working effectively with (-support-) the community - Daniel Westermann
This talk is for those who are new to PostgreSQL or those who just started, or all the others that want to hear a personal story: When I started with PostgreSQL around 10 years ago, I came with an Oracle background. It took me quite some time to u...
-
Talkception : why non-technical talks in tech events are so important - Magali Milbergue
We often judge tech events by the quality of their technical talks. And after all, why not ? It seems totally fair as we probably go to these events to learn all the new infos about our favorite tools, we want to learn the hot new good practices, ...
-
Documentation : Let’s make it better, now, together! - Sarah Haïm-Lubczanski
Documentation is the best way to capture knowledge and let all the users, from beginners to advanced PostgreSQL users, learn more and make progress. Let's pick some documentation pages of your favorite software and improve it directly in real-time...
-
PostGIS for Newbies - Elizabeth Garrett Christensen
Calling anyone who loves maps and location data! PostGIS is the open source geospatial extension to PostgreSQL and it's super easy to get started with. This talk is a live demo and walkthrough of the basics of PostGIS. From importing geospatial da...
-
PostGIS for Newbies - Elizabeth Garrett Christensen
Calling anyone who loves maps and location data! PostGIS is the open source geospatial extension to PostgreSQL and it's super easy to get started with. This talk is a live demo and walkthrough of the basics of PostGIS. From importing geospatial da...
-
Documentation : Let’s make it better, now, together! - Sarah Haïm-Lubczanski
Documentation is the best way to capture knowledge and let all the users, from beginners to advanced PostgreSQL users, learn more and make progress. Let's pick some documentation pages of your favorite software and improve it directly in real-time...
-
Talkception : why non-technical talks in tech events are so important - Magali Milbergue
We often judge tech events by the quality of their technical talks. And after all, why not ? It seems totally fair as we probably go to these events to learn all the new infos about our favorite tools, we want to learn the hot new good practices, ...
-
Working effectively with (-support-) the community - Daniel Westermann
This talk is for those who are new to PostgreSQL or those who just started, or all the others that want to hear a personal story: When I started with PostgreSQL around 10 years ago, I came with an Oracle background. It took me quite some time to u...
-
PostgreSQL and Software Engineers - Henrietta Dombrovskaya
Those who often interact with application developers know how often these developers are upset with us, with PostgreSQL, and with databases in general. In addition to the usual complaints that "databases are slow" and "database developers are slow...
-
Upgrade Postgres! - Lætitia AVROT
Postgres is stable, too stable, so stable that we sometimes forget that it still needs maintenance. Upgrading Postgres regularly is part of the routine maintenance that most people won't do. That's why we see so many Postgres clusters still in Pos...
-
Large Databases, Lots of Servers, on Premises, in the Cloud - Get Them All! — Flavio Gurgel
This talk is an overview of the leboncoin's real infrastructure and how we manage PostgreSQL to be webscale as the database of choice of the 5th most accessed web site in France: handling tens of databases and servers using automation, guar...
-
Bitemporality in PostgreSQL: Update Your Data Without Losing Information — Miroslav Šedivý
So you finally have your database model for your application and you fill it in with current data. How do you keep it up to date? While INSERT may still be transparent, UPDATE and DELETE will overwrite your previous data, so you won't be able to r...
-
PostgreSQL As Data Integration Tool — Stefanie Janine Stölting
Instead of using ETL Tools, which consume tons of memory on their own system, you will learn how to do ETL jobs directly in and with a database. The PostgreSQL implementation of the the standard ISO/IEC 9075-9:2016, Management of External Data (SQ...
-
Breaking PostgreSQL at Scale — Christophe Pettus
Database systems don't just slow down in a clear, linear way. They reach a certain point and start failing, often very suddenly and surprisingly. This talk is about some of the most common scaling "discontinuities" in PostgreSQL, and how to pla...
-
Don't Forget Materialized Views — Stéphanie Baltus
When exposing data to an user interface, we often find ourselves needing to speed up the response time. PostgreSQL offers plenty of solutions for that such as different types of indexes, parallel queries and so on. But since the 9.3 version, Postg...
-
Be Inclusive: Welcome Non-Key Columns in B-Tree Indexes — Markus Winand
PostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities t...
-
pgDay Paris 2019
A look back at pgDay Paris 2019.
-
So You’ll be Working With (women or other under-represented groups) Other People! — Renee Phillips
An introduction to the tools, sites, and concepts available to aid in working with people from a variety of backgrounds. This talk will include some sociology and some global statistics. While not Postgres specific, this talk addresses the impact ...
-
How to Write SQL Queries — Dimitri Fontaine
Most of the time we see finished SQL queries, either in code repositories, blog posts of talk slides. This talk focus on the process of how to write an SQL query, from a problem statement expressed in English to code review and long term maintenan...
-
pgDay Paris 2019
A look back at pgDay Paris 2019.
-
So You’ll be Working With (women or other under-represented groups) Other People! — Renee Phillips
An introduction to the tools, sites, and concepts available to aid in working with people from a variety of backgrounds. This talk will include some sociology and some global statistics. While not Postgres specific, this talk addresses the impact ...
-
How to Write SQL Queries — Dimitri Fontaine
Most of the time we see finished SQL queries, either in code repositories, blog posts of talk slides. This talk focus on the process of how to write an SQL query, from a problem statement expressed in English to code review and long term maintenan...
-
Be Inclusive: Welcome Non-Key Columns in B-Tree Indexes — Markus Winand
PostgreSQL 11 introduced the INCLUDE clause for b-tree indexes. The main intention of this clause is to enable Index Only Scans without including selected columns into the index key. But the INCLUDE clause has many other interesting capabilities t...
-
Don't Forget Materialized Views — Stéphanie Baltus
When exposing data to an user interface, we often find ourselves needing to speed up the response time. PostgreSQL offers plenty of solutions for that such as different types of indexes, parallel queries and so on. But since the 9.3 version, Postg...
-
Breaking PostgreSQL at Scale — Christophe Pettus
Database systems don't just slow down in a clear, linear way. They reach a certain point and start failing, often very suddenly and surprisingly. This talk is about some of the most common scaling "discontinuities" in PostgreSQL, and how to pla...
We're indexing this podcast's transcripts for the first time — this can take a minute or two. We'll show results as soon as they're ready.
No matches for "" in this podcast's transcripts.
No topics indexed yet for this podcast.
Loading reviews...
ABOUT THIS SHOW
No description available.
Loading similar podcasts...
Frequently Asked Questions
How many episodes does PgDay Paris have?
PgDay Paris currently has 43 episodes available on PodParley. New episodes are automatically indexed when they're published to the podcast feed.
What is PgDay Paris about?
PgDay Paris is a podcast covering topics in various topics.
How often does PgDay Paris release new episodes?
PgDay Paris has 43 episodes. Check the episode list to see recent publication dates and frequency.
Where can I listen to PgDay Paris?
You can listen to PgDay Paris on PodParley by clicking any episode. We provide an embedded audio player for direct listening, and you can also subscribe via your preferred podcast app using the RSS feed.
URL copied to clipboard!