Re: vacuum and postgresql.conf settings

Поиск
Список
Период
Сортировка
От Walter Vaughan
Тема Re: vacuum and postgresql.conf settings
Дата
Msg-id 4672DA54.40105@steelerubber.com
обсуждение исходный текст
Ответ на Re: vacuum and postgresql.conf settings  (Francisco Reyes <lists@stringsutils.com>)
Ответы Re: vacuum and postgresql.conf settings  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Francisco Reyes wrote:

> Walter Vaughan writes:
>> I am not even sure this is a problem.
>> INFO:  "data_import_customer2": scanned 3000 of 5033 pages, containing
>> 84905 live rows and 0 dead rows; 3000 rows in sample, 142442 estimated
>> total rows
>
> I don't believe it is a problem.
> I think it is just normal output of the vacuum.
> What made you think there could be a problem?

Well, why did it only scan 3000 pages out of 5033? It decided it didn't need to?
It took a sample and decided it was gonna be okay?

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

Предыдущее
От: PFC
Дата:
Сообщение: Re: Postmaster processes taking all the CPU
Следующее
От: MC Moisei
Дата:
Сообщение: Re: Postmaster processes taking all the CPU