Re: [HACKERS] Slow count(*) again...

Поиск
Список
Период
Сортировка
От Jeremy Harris
Тема Re: [HACKERS] Slow count(*) again...
Дата
Msg-id 4D4B4862.20203@wizmail.org
обсуждение исходный текст
Ответ на Re: [HACKERS] Slow count(*) again...  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-performance
On 2011-02-03 23:29, Robert Haas wrote:
> Yeah, but you'll be passing the entire table through this separate
> process that may only need to see 1% of it or less on a large table.

It doesn't sound too impossible to pass only a percentage, starting high
and dropping towards 1% once the loaded size has become "large".
--
Jeremy

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

Предыдущее
От: Mladen Gogala
Дата:
Сообщение: Re: [HACKERS] Slow count(*) again...
Следующее
От: Jeremy Harris
Дата:
Сообщение: Re: [HACKERS] Slow count(*) again...