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
