On Sun, 2021-05-09 at 19:18 -0400, John Scalia wrote:
> I have a dev team requesting that I partition 3 very large tables with more 2 billion rows each.
> I’ve already got the partition key decided for each with a script which will create a copy of
> original with the partition declaration, along with the partition child tables.
> [...]
> FYI, this is production instance that is regularly updated by field technicians.
> Quite literally, I cannot perform two sequential select count(*) from any of these tables
> which will return the same row counts.
From v13 on, you should be able to use logical replication to partition a table with
little downtime.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com