Re:

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Denis Gasparin <denis(at)edinet(dot)it>
Cc: Doug McNaught <doug(at)wireboard(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re:
Date: 2001-08-24 13:41:30
Message-ID: 2972.998660490@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Denis Gasparin <denis(at)edinet(dot)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

In response to

  • Re: at 2001-08-24 10:20:37 from Denis Gasparin

Browse pgsql-general by date

  From Date Subject
Next Message Miroslav Koncar 2001-08-24 13:45:36 Re: problems transfering databases
Previous Message Denis Gasparin 2001-08-24 13:35:01 Re: BIGINT datatype and Indexes Failure