On Mon, 11 Oct 2004, John Meinel wrote:
> Postgres believes that it will cost 382 to do a sequential scan, versus 490
> for an indexed scan. Hence why it prefers to do the sequential scan. Try
> running explain analyze to see if how accurate it is.
With explain analyze I have with sequential scan on
Sort (cost=382.01..382.15 rows=56 width=196)
(actual time=64.346..64.469 rows=24 loops=1)
And with seqscan off
Sort (cost=490.82..490.96 rows=56 width=196)
(actual time=56.668..56.789 rows=24 loops=1)
So I guess that for this particular query I am better off setting the
seqscan off.
