Re: Speeding up select distinct

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Laurent Martelli" <laurent(at)aopsys(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Speeding up select distinct
Date: 2005-03-16 18:07:21
Message-ID: opsnqsmjvlth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Try :

SELECT owner from pictures group by owner;

> Any ideas, apart from more or less manually maintaining a list of
> distinct owners in another table ?

That would be a good idea too for normalizing your database.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-03-16 18:09:24 Re: multi-column index
Previous Message Josh Berkus 2005-03-16 18:03:10 Re: cpu_tuple_cost