Re: - Mailing list pgsql-general

From Tom Lane
Subject Re:
Date
Msg-id 2972.998660490@sss.pgh.pa.us
Whole thread Raw
In response to Re:  (Denis Gasparin <denis@edinet.it>)
List pgsql-general
Denis Gasparin <denis@edinet.it> writes:
> Is it possible that the query planner thinks that is best a sequential scan
> when an index on the table is present?

Possibly.  It all depends on the statistics.  You have not shown us the
EXPLAIN results obtained after doing VACUUM ANALYZE...

            regards, tom lane

pgsql-general by date:

Previous
From: Denis Gasparin
Date:
Subject: Re: BIGINT datatype and Indexes Failure
Next
From: Tom Lane
Date:
Subject: Re: BIGINT datatype and Indexes Failure