Re: Mysteriously varying index scan costs

2018-09-24 Thread Laurenz Albe
Pavan Deolasee wrote: > On Mon, Sep 24, 2018 at 2:20 PM, Laurenz Albe > wrote: > > > > But how can it be that the first run has to touch 74917 blocks, > > while whe second run only needs to touch 1185? > > > > The first index scan may have killed lots of index tuples. So the first index scan

Re: Mysteriously varying index scan costs

2018-09-24 Thread Pavan Deolasee
On Mon, Sep 24, 2018 at 2:20 PM, Laurenz Albe wrote: > > > But how can it be that the first run has to touch 74917 blocks, > while whe second run only needs to touch 1185? > > The first index scan may have killed lots of index tuples. Thanks, Pavan -- Pavan Deolasee http://w