Re: Seq Scans when index expected to be used

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ow <oneway_111(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Seq Scans when index expected to be used
Date: 2003-11-29 17:24:10
Message-ID: 7718.1070126650@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

ow <oneway_111(at)yahoo(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joe Conway 2003-11-29 17:26:43 Re: Seq Scans when index expected to be used
Previous Message jasiek 2003-11-29 17:21:23 Re: Seq Scans when index expected to be used