Postgres Pro
Downloads
Home   >   mailing lists

Re: Seq Scans when index expected to be used - Mailing list pgsql-sql

From Tom Lane
Subject Re: Seq Scans when index expected to be used
Date
Msg-id 7718.1070126650@sss.pgh.pa.us
Whole thread Raw
In response to Seq Scans when index expected to be used  (ow <oneway_111@yahoo.com>)
List pgsql-sql
Tree view 
ow <oneway_111@yahoo.com> writes:
> Am trying to find duplicate values in a large table (about 80M records).
> Somehow, none of the two (2) queries (see below) is using the index "I_bca"
> that, I believe, should've been used.

Those plans are perfectly reasonable (particularly the GroupAggregate one).
        regards, tom lane

pgsql-sql by date:

Previous
From: "jasiek"
Date:
Subject: Re: Seq Scans when index expected to be used
Next
From: Joe Conway
Date:
Subject: Re: Seq Scans when index expected to be used