| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Victor Yegorov <vyegorov(at)gmail(dot)com> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Relation cache invalidation on replica |
| Date: | 2017-04-19 20:08:28 |
| Message-ID: | 20170419200828.r5zcvddxicrndafp@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2017-04-19 17:07:49 +0300, Victor Yegorov wrote:
> 2017-03-13 9:22 GMT+02:00 Andres Freund <andres(at)anarazel(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-04-19 20:10:23 | Re: Ongoing issues with representation of empty arrays |
| Previous Message | Peter Eisentraut | 2017-04-19 19:57:35 | Re: logical replication and PANIC during shutdown checkpoint in publisher |