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

From Andres Freund
Subject Re: [HACKERS] Relation cache invalidation on replica
Date
Msg-id 20170419200828.r5zcvddxicrndafp@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] Relation cache invalidation on replica  (Victor Yegorov <vyegorov@gmail.com>)
Responses Re: [HACKERS] Relation cache invalidation on replica  (Victor Yegorov <vyegorov@gmail.com>)
List pgsql-hackers
On 2017-04-19 17:07:49 +0300, Victor Yegorov wrote:
> 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?

I was thinking of c6ff84b06a68b71719aa1aaa5f6704d8db1b51f8

- Andres



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] logical replication and PANIC during shutdowncheckpoint in publisher
Next
From: "David G. Johnston"
Date:
Subject: Re: [HACKERS] Ongoing issues with representation of empty arrays