Re: Speeding up select distinct - Mailing list 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.