| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)kurilemu(dot)de> |
| Cc: | Radim Marek <radim(at)boringsql(dot)com>, shihao zhong <zhong950419(at)gmail(dot)com>, Antonin Houska <ah(at)cybertec(dot)at>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: REPACK (CONCURRENTLY) can't complete after ~105M concurrent updates/deletes |
| Date: | 2026-10-08 13:50:50 |
| Message-ID: | asefusFKZworw-Ac@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Oct 08, 2026 at 02:34:50PM +0200, Alvaro Herrera wrote:
> On 2026-Oct-08, Radim Marek wrote:
>> As a medium-heavy repack user over the last decade, I'd say this limit is
>> acceptable for now.
>
> Agreed -- I don't think we need any localized hacking for this,
> considering that we have a patch in the queue for 20 that will
> completely remove the need for this. People that can't tolerate 105
> million rows concurrently updated during REPACK (CONCURRENTLY) can do
> whatever they've been doing so far to cope with such a scenario. Maybe
> they run pg_repack, or maybe they run VACUUM FULL, I don't really care.
> (What I actually think is that such people don't actually exist.)
>
> IMO this is not a regression and we don't *need* to cope with it.
Okay. It sounds like we have carefully considered this behavior and deemed
it acceptable for now, and I do not intend to press the issue any further.
Thanks!
--
nathan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Geier | 2026-10-08 13:51:20 | Re: Improving scalability of Parallel Bitmap Heap/Index Scan |
| Previous Message | Robert Haas | 2026-10-08 13:49:26 | Re: pgsql: Teach expr_is_nonnullable() to handle more expression types |