Re: select distinct and index usage

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: David Wilson <david(dot)t(dot)wilson(at)gmail(dot)com>, Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, pgsql-general(at)postgresql(dot)org
Subject: Re: select distinct and index usage
Date: 2008-04-08 02:16:58
Message-ID: 20080408021658.GJ5095@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane escribió:

> What I think you'll find, though, is that once you do force an indexscan
> to be picked it'll be slower. Full-table index scans are typically
> worse than seqscan+sort, unintuitive though that may sound.

Hmm, should we switch the CLUSTER code to do that?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-04-08 02:30:31 Re: select distinct and index usage
Previous Message Tom Lane 2008-04-08 02:15:03 Re: select distinct and index usage