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'm not at my computer right now, but I recall committing something like my approach.>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?
Andres, can you point me on the commit you're mentioning, please?
--
Victor Yegorov
В списке pgsql-hackers по дате отправления: