Re: [HACKERS] Relation cache invalidation on replica

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: [HACKERS] Relation cache invalidation on replica
Дата
Msg-id CAGnEbogjOh57Pf6MvpDWirW=5Q=UgH5-eDztbrxhPp51LWwM7w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Relation cache invalidation on replica  (Andres Freund <andres@anarazel.de>)
Ответы Re: [HACKERS] Relation cache invalidation on replica
Список pgsql-hackers
2017-03-13 9:22 GMT+02:00 Andres Freund <andres@anarazel.de>:
>I think we're hitting this particular issue quite frequently when
>rebuilding indexes on master after big-volume data manipulations.
>
>We have `pgbouncer` in transaction mode for both, master and slave,
>therefore it's quite typical to have sessions on slave, that
>were using indexes before those we're re-created. Sad, but right now
>maintenance is a big performance hit for our applications,
>we have to re-connect them to start using indexes again.
>
>Are there any chances to get fix for this issue released in 10.0 and,
>perhaps, backpatched also?

I'm not at my computer right now, but I recall committing something like my approach.

Andres, can you point me on the commit you're mentioning, please?


--
Victor Yegorov

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: [HACKERS] BuildFarm client release 4.19
Следующее
От: Remi Colinet
Дата:
Сообщение: Re: [HACKERS] [PATCH] New command to monitor progression of longrunning queries