Re: Ideas for a relcache test mode about missing invalidations

2018-08-08 Thread Kyotaro HORIGUCHI
Hello. At Fri, 3 Aug 2018 15:42:22 -0700, Peter Geoghegan wrote in > On Fri, Aug 3, 2018 at 12:34 AM, Kyotaro HORIGUCHI > wrote: > >> I reread through the thread and IUCC, drop_index() is sending > >> inval on the owing relation and invalidation happens (that is, > > > > I finally understand

Re: Ideas for a relcache test mode about missing invalidations

2018-08-03 Thread Peter Geoghegan
On Fri, Aug 3, 2018 at 12:34 AM, Kyotaro HORIGUCHI wrote: >> I reread through the thread and IUCC, drop_index() is sending >> inval on the owing relation and invalidation happens (that is, > > I finally understand that I was totally inept. This came from > *the result* of the original -bug

Re: Ideas for a relcache test mode about missing invalidations

2018-08-03 Thread Kyotaro HORIGUCHI
At Wed, 1 Aug 2018 09:25:18 -0700, Andres Freund wrote in <20180801162518.jnb2ql5dfmgwp...@alap3.anarazel.de> > Hi, > > The issue at [1] is caused by missing invalidations, and [2] seems like > a likely candidate too. I wonder if it'd be good to have a relcache test > mode akin to

Re: Ideas for a relcache test mode about missing invalidations

2018-08-03 Thread Kyotaro HORIGUCHI
Hello. At Fri, 03 Aug 2018 10:54:46 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI wrote in <20180803.105446.155966888.horiguchi.kyot...@lab.ntt.co.jp> > I reread through the thread and IUCC, drop_index() is sending > inval on the owing relation and invalidation happens (that is, I finally

Re: Ideas for a relcache test mode about missing invalidations

2018-08-02 Thread Kyotaro HORIGUCHI
At Thu, 2 Aug 2018 14:40:50 -0700, Peter Geoghegan wrote in pg> On Thu, Aug 2, 2018 at 3:18 AM, Kyotaro HORIGUCHI pg> wrote: pg> >> [1] http://archives.postgresql.org/message-id/CAKoxK%2B5fVodiCtMsXKV_1YAKXbzwSfp7DgDqUmcUAzeAhf%3DHEQ%40mail.gmail.com pg> >> [2]

Re: Ideas for a relcache test mode about missing invalidations

2018-08-02 Thread Peter Geoghegan
On Thu, Aug 2, 2018 at 3:18 AM, Kyotaro HORIGUCHI wrote: >> [1] >> http://archives.postgresql.org/message-id/CAKoxK%2B5fVodiCtMsXKV_1YAKXbzwSfp7DgDqUmcUAzeAhf%3DHEQ%40mail.gmail.com >> [2] https://www.postgresql.org/message-id/12259.1532117...@sss.pgh.pa.us > > As for [1], it is not a issue on

Re: Ideas for a relcache test mode about missing invalidations

2018-08-02 Thread Andres Freund
Hi, On 2018-08-02 19:18:11 +0900, Kyotaro HORIGUCHI wrote: > At Wed, 1 Aug 2018 09:25:18 -0700, Andres Freund wrote > in <20180801162518.jnb2ql5dfmgwp...@alap3.anarazel.de> > > Hi, > > > > The issue at [1] is caused by missing invalidations, and [2] seems like > > a likely candidate too. I

Re: Ideas for a relcache test mode about missing invalidations

2018-08-02 Thread Kyotaro HORIGUCHI
Hello. At Wed, 1 Aug 2018 09:25:18 -0700, Andres Freund wrote in <20180801162518.jnb2ql5dfmgwp...@alap3.anarazel.de> > Hi, > > The issue at [1] is caused by missing invalidations, and [2] seems like > a likely candidate too. I wonder if it'd be good to have a relcache test > mode akin to

Ideas for a relcache test mode about missing invalidations

2018-08-01 Thread Andres Freund
Hi, The issue at [1] is caused by missing invalidations, and [2] seems like a likely candidate too. I wonder if it'd be good to have a relcache test mode akin to CLOBBER_CACHE_ALWAYS and RELCACHE_FORCE_RELEASE, that tries to ensure that we've done sufficiently to ensure the right invalidations