still a heap scan on alf_node instead of using the index -
what should my next move be ? Change the stats collection level on store_id
and type_qname_id on alf_node - or reindex alf_node ?
On Thu, Jan 30, 2020 at 4:36 PM Tom Lane wrote:
> Duncan Whitham writes:
> > We now only
g after
> your initial email but before you did the above, meaning there was not much
> for your manual to do.
>
> But you can see that the vacuum did have an effect, by comparing these
> lines (despite them finding about same number of rows)
>
> Heap Blocks: exact=40765
>
>
