Re: select count(distinct ...) is slower than select distinct in about 5x

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: jacket41142 <jacket41142(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: select count(distinct ...) is slower than select distinct in about 5x
Date: 2013-12-10 18:16:40
Message-ID: 1386699400.50339.YahooMailNeo@web162903.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

jacket41142 <jacket41142(at)gmail(dot)com> wrote:

> [ subject issue in detail ]

Please review this thread:

http://www.postgresql.org/message-id/flat/CAPNY-2Utce-c+kNTwsMCbAk58=9mYeAeViTXT9LO7r1k77jukw(at)mail(dot)gmail(dot)com#CAPNY-2Utce-c+kNTwsMCbAk58=9mYeAeViTXT9LO7r1k77jukw@mail.gmail.com

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2013-12-10 18:19:46 Re: select count(distinct ...) is slower than select distinct in about 5x
Previous Message jacket41142 2013-12-10 17:28:22 select count(distinct ...) is slower than select distinct in about 5x