Postgres Pro
Downloads
Home   >   mailing lists

How slow is DISTINCT? - Mailing list pgsql-sql

From Wei Weng
Subject How slow is DISTINCT?
Date
Msg-id 3C7D252A.3030608@kencast.com
Whole thread Raw
Responses Re: How slow is DISTINCT?  ("Josh Berkus" <josh@agliodbs.com>)
Re: How slow is DISTINCT?  ("Dan Langille" <dan@langille.org>)
List pgsql-sql
Tree view 
I tend to use DISTINCT a lot in my queries to limit the repeated rows.
Is that a good habbit?

How exactly slow is DISTINCT being processed in SQL engines? (not
limited to postgresql, though comments on postgresql would be most relevant)

Thanks

-- 
Wei Weng
Network Software Engineer
KenCast Inc.

pgsql-sql by date:

Previous
From: Jeff Self
Date:
Subject: Re: implementation of a many-to-many relationship
Next
From: "Dan Langille"
Date:
Subject: Re: implementation of a many-to-many relationship