Re: why does count take so long?

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: why does count take so long?
Дата
Msg-id 3F5D1205.6030703@selectacast.net
обсуждение исходный текст
Ответ на Re: why does count take so long?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:

> Unless Joseph's machine has a way better IO-to-CPU ratio than my little
> development machine, there's something odd about his numbers.
>
>             regards, tom lane
Doing some math:

81372.11 / 71542.53 : 1.1373949174008804
189865.81 / 163833.61 : 1.1588941365572059

So I have count() taking 14% over the seqscan, and you have 16%


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: About GPL and proprietary software
Следующее
От: Greg Stark
Дата:
Сообщение: Another pimple on the type system