Re: Understanding "seq scans" - Mailing list pgsql-general

From Lele Gaifax
Subject Re: Understanding "seq scans"
Date
Msg-id 87eggz6xva.fsf@metapensiero.it
Whole thread Raw
In response to Understanding "seq scans"  (Lele Gaifax <lele@metapensiero.it>)
List pgsql-general
Merlin Moncure <mmoncure@gmail.com> writes:

> Your data and indexes are organized such that an index is only marginally
> helpful, or so the planner thinks.

Yes, just wanted to get rid of that suspicious "seq scan", that was
effectively caused by a bad index, as Alvaro pointed out.

Thank you,
ciao, lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
lele@metapensiero.it  |                 -- Fortunato Depero, 1929.

pgsql-general by date:

Previous
From: Lele Gaifax
Date:
Subject: Re: Understanding "seq scans"
Next
From: Mikhail
Date:
Subject: hanged session on index creation