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

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: select count(distinct ...) is slower than select distinct in about 5x
Дата
Msg-id 1386699400.50339.YahooMailNeo@web162903.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на select count(distinct ...) is slower than select distinct in about 5x  (jacket41142 <jacket41142@gmail.com>)
Список pgsql-performance
jacket41142 <jacket41142@gmail.com> wrote:

> [ subject issue in detail ]

Please review this thread:


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

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


В списке pgsql-performance по дате отправления:

Предыдущее
От: jacket41142
Дата:
Сообщение: select count(distinct ...) is slower than select distinct in about 5x
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: select count(distinct ...) is slower than select distinct in about 5x