pg.ddx.io  reorg/pg_repack GitHub issues and pull requests  
help / color / mirror / Atom feed
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.

view thread (6+ messages)

Message-ID: <gh-reorg-pg_repack-485-c5365405370@github.com>
Permalink:  ../gh-reorg-pg_repack-485-c5365405370@github.com/

 · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox