On Wed, Sep 22, 2021 at 2:48 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > "David G. Johnston" <david.g.johns...@gmail.com> writes: > > There is no where clause so I'm doubtful there is much to be gained going > > down this path. The Index-Only scan seems like an optimal way to obtain > > this data and the existing query already does that. > > The "index-only" scan is reported to do 86m heap fetches along the > way to returning 812m rows, so the data is apparently pretty dirty. >
Do you say that because you would expect many more than 10 tuples per page?
