Viewing entries tagged with partitioning. Return to full view.

Repartitioning with logical replication in PostgreSQL 13

So, you have a partitioned table. And you want to change your mind. Re-partitioning is "easy" if you can take downtime -- just create a new table with a new name and copy all the data over. But what if we want to try to do it without downtime? Logical replication enhancements in PostgreSQL 13 brings us some new options for this!

But first a disclaimer -- this is definitely not pretty! And does not take into consideration things like foreign keys and similar. But sometimes a quick hack can be the best hack.

So let's go!

Continue reading

Conferences

I speak at and organize conferences around Open Source in general and PostgreSQL in particular.

Upcoming

PGDay/MED 2023
Apr 13, 2023
St Julian's, Malta
PGDay Chicago 2023
Apr 20, 2023
Chicago, USA
PGCon 2023
May 30-Jun 2, 2023
Ottawa, Canada
PGConf.EU 2023
Dec 12-15, 2023
Prague, Czechia

Past

pgday.Paris 2023
Mar 23, 2023
Paris, France
Nordic PGDay 2023
Mar 21, 2023
Stockholm, Sweden
SCaLE 2023
Mar 9-12, 2023
Pasadena, CA, USA
FOSDEM 2023
Feb 2-5, 2023
Brussels, Belgium
PGConf.EU 2022
Oct 25-28, 2022
Berlin, Germany
More past conferences