Re: Slow count(*) again...

Поиск
Список
Период
Сортировка
От david@lang.hm
Тема Re: Slow count(*) again...
Дата
Msg-id alpine.DEB.2.00.1010131237010.30818@asgard.lang.hm
обсуждение исходный текст
Ответ на Re: Slow count(*) again...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Wed, 13 Oct 2010, Tom Lane wrote:

> Neil Whelchel <neil.whelchel@gmail.com> writes:
>
> That's probably got little to do with caching and everything to do with
> setting hint bits on the first SELECT pass.
>
> I concur with Mark's question about whether your UPDATE pushed the table
> size across the limit of what would fit in RAM.

Neil, can you just double the size of your initial test to make sure that
it's too large to fit in ram to start with?

David Lang

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: Bogus startup cost for WindowAgg
Следующее
От: Neil Whelchel
Дата:
Сообщение: Re: Slow count(*) again...