Re: Logical Replication speed-up initial data

Поиск
Список
Период
Сортировка
От Rick Otten
Тема Re: Logical Replication speed-up initial data
Дата
Msg-id CAMAYy4JXMridMf7utNt0+J9DA+0oOYFY8rPK7ssumKPj1zNfmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logical Replication speed-up initial data  (Nikhil Shetty <nikhil.dba04@gmail.com>)
Список pgsql-performance

On Thu, Aug 5, 2021 at 12:57 AM Nikhil Shetty <nikhil.dba04@gmail.com> wrote:
Hi,

Thank you for the suggestion.

We tried by dropping indexes and it worked faster compared to what we saw earlier. We wanted to know if anybody has done any other changes that helps speed-up initial data load without dropping indexes.

It would be kind of cool if the database could just "know" that it was an initial load and automatically suppress FK checks and index updates until the load is done.  Once complete it would go back and concurrently rebuild the indexes and validate the FK's.   Then you wouldn't have to manually drop all of your indexes and add them back and hope you got them all, and got them right.

 

В списке pgsql-performance по дате отправления:

Предыдущее
От: Nikhil Shetty
Дата:
Сообщение: Re: Logical Replication speed-up initial data
Следующее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Logical Replication speed-up initial data