Re: Intermittent BRIN failures on hyrax and lousyjack

2020-07-09 Thread Alvaro Herrera
On 2020-Jul-09, Alvaro Herrera wrote: > I have a moment now, let me have a go at it. I agree with deleting the > message. I think I'll keep the comment, slightly reworded: > > /* >* Placeholder tuples only appear during unfinished summarization, and > we >* hold SUE lock,

Re: Intermittent BRIN failures on hyrax and lousyjack

2020-07-09 Thread Alvaro Herrera
On 2020-Jul-09, Tom Lane wrote: > Alvaro Herrera writes: > > On 2020-Jun-30, Tom Lane wrote: > >> SELECT brin_desummarize_range('brinidx', 0); > >> +WARNING: leftover placeholder tuple detected in BRIN index "brinidx", > >> deleting > > >> So (1) the comment needs to be adjusted to mention tha

Re: Intermittent BRIN failures on hyrax and lousyjack

2020-07-09 Thread Tom Lane
Alvaro Herrera writes: > On 2020-Jun-30, Tom Lane wrote: >> SELECT brin_desummarize_range('brinidx', 0); >> +WARNING: leftover placeholder tuple detected in BRIN index "brinidx", >> deleting >> So (1) the comment needs to be adjusted to mention that vacuum >> cancellation is enough to create th

Re: Intermittent BRIN failures on hyrax and lousyjack

2020-06-30 Thread Alvaro Herrera
On 2020-Jun-30, Tom Lane wrote: > SELECT brin_desummarize_range('brinidx', 0); > +WARNING: leftover placeholder tuple detected in BRIN index "brinidx", > deleting > I think the "crash" actually was the forced autovac cancellation we see > here. Thus, the fact that both these animals use CLOBB