Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations
Дата
Msg-id CAKAnmmLwWxntKiDjnY=wPK93TomdSAuheXJix1d6sZVze_HNPg@mail.gmail.com
обсуждение исходный текст
Ответ на [Feature Request] INSERT FROZEN to Optimize Large Cold Data Imports and Migrations  (Sébastien <bokanist@gmail.com>)
Список 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 по дате отправления: