On 2017-04-19 17:07:49 +0300, Victor Yegorov wrote: > 2017-03-13 9:22 GMT+02:00 Andres Freund <and...@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?
I was thinking of c6ff84b06a68b71719aa1aaa5f6704d8db1b51f8 - Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers