Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations
Date
Msg-id CAKAnmmLwWxntKiDjnY=wPK93TomdSAuheXJix1d6sZVze_HNPg@mail.gmail.com
Whole thread Raw
In response to [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations  (Sébastien <bokanist@gmail.com>)
List pgsql-hackers
On Thu, Feb 13, 2025 at 9:45 AM Sébastien <bokanist@gmail.com> wrote:
This issue is particularly critical during database migrations or version upgrades, where a full data reload is often necessary. Each time a major PostgreSQL upgrade occurs, users must reimport large datasets, leading to the same problem of vacuum storms post import.

What major upgrade process are you doing that uses INSERT?

Cheers,
Greg
--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: BitmapHeapScan streaming read user and prelim refactoring
Next
From: Tomas Vondra
Date:
Subject: Re: BitmapHeapScan streaming read user and prelim refactoring