Horton

Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function

Andres Freund <andres@anarazel.de>

View thread View on postgr.es
From: Andres Freund <andres@anarazel.de>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Luca Ferrari <fluca1978@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@postgresql.org>, pgsql-general <pgsql-general@postgresql.org>
Date: 2018-07-25T23:03:24Z
Lists: pgsql-bugs, pgsql-general 
Hi,

On 2018-07-09 12:06:21 -0700, Peter Geoghegan wrote:
> > I assume we'll have to backpatch this issue, so I think it'd probably a
> > good idea to put a specific CacheInvalidateHeapTuple() in there
> > explicitly in the back branches, and do the larger fix in 12. ISTM
> > there's some risks that it'd cause issues.  Will you tackle this?
> 
> Okay.

Any progress on that?

Peter, given that your patch made this more likely, and that you're a
committer these days, I'm opening an open items entry, and assign it to
you. Does that sound ok?

Greetings,

Andres Freund

Commits

  1. Add table relcache invalidation to index builds.