Re: Slow WAL recovery for DROP TABLE

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Slow WAL recovery for DROP TABLE
Дата
Msg-id CAMkU=1znu3UnsunV_kODRKJEy-K-Kh9qmvvz3wC3EY4Wi6-8TQ@mail.gmail.com
обсуждение исходный текст
Ответ на Slow WAL recovery for DROP TABLE  (Sherrylyn Branchaw <sbranchaw@gmail.com>)
Ответы Re: Slow WAL recovery for DROP TABLE
Список pgsql-general

There was a recent commit for a similar performance problem, which will appear in 9.6.10.  But that was specifically for cases where there were multiple dropped tables per transaction, and large shared_buffers.

I can't reproduce your single-drop-per-transaction problem.  The replica has no problem keeping up with the master.

Can you share the reproduction scripts, and any non-default config settings?  Especially the setting of shared_buffers (on both master and replica, if different)

Cheers,

Jeff

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

Предыдущее
От: Sherrylyn Branchaw
Дата:
Сообщение: Slow WAL recovery for DROP TABLE
Следующее
От: Márcio Antônio Sepp
Дата:
Сообщение: Can't compile postgresql 11 on FreeBSD 11.1