From: sawanoboly (@sawanoboly) <noreply+sawanoboly@github.com>
To: reorg/pg_repack <noreply+reorg-pg_repack@github.com>
Subject: Re: [reorg/pg_repack] issue #485: Consider an option to build indexes before copying data during table repack
Date: Fri, 21 Aug 2026 05:00:52 +0000
Message-ID: <gh-reorg-pg_repack-485-c5365405370@github.com> (raw)
In-Reply-To: <gh-reorg-pg_repack-485@github.com>
References: <gh-reorg-pg_repack-485@github.com>
As an additional note, we are of course already working on partitioning the large historical data as well.
We are gradually splitting the large historical partition into smaller partitions during periods of low operational load. This is a rather cumbersome process that we are carrying out in parallel with the repacking effort.
So the proposed option is not intended as an alternative to partitioning, but as a way to deal with the large amount of legacy data that still needs to be reorganized while that partitioning work is underway.