Postgres Pro
Downloads
Home   >   mailing lists

Re: sequential scan on select distinct - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: sequential scan on select distinct
Date
Msg-id opsfjpxni1cq72hf@musicbox
Whole thread Raw
In response to Re: sequential scan on select distinct  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: execute cursor fetch
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: integer[] indexing.
Next
From: Harald Fuchs
Date:
Subject: Re: integer[] indexing.