Re: sequential scan on select distinct

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: sequential scan on select distinct
Date: 2004-10-08 09:57:13
Message-ID: opsfjpxni1cq72hf@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


> Hashing is at least as fast, if not faster.
> regards, tom lane

Probably quite faster if the dataset is not huge...
UniqueSort would be useful for GROUP BY x ORDER BY x though

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Harding 2004-10-08 12:10:29 COPY slows down?
Previous Message Pierre-Frédéric Caillaud 2004-10-08 09:29:35 Re: integer[] indexing.