Re: [HACKERS] Relation cache invalidation on replica - Mailing list pgsql-hackers

From Victor Yegorov
Subject Re: [HACKERS] Relation cache invalidation on replica
Date
Msg-id CAGnEbogjOh57Pf6MvpDWirW=5Q=UgH5-eDztbrxhPp51LWwM7w@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Relation cache invalidation on replica  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] Relation cache invalidation on replica  (Andres Freund <andres@anarazel.de>)
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: [HACKERS] BuildFarm client release 4.19
Next
From: Remi Colinet
Date:
Subject: Re: [HACKERS] [PATCH] New command to monitor progression of longrunning queries