Re: vacuum and postgresql.conf settings - Mailing list pgsql-general

From Walter Vaughan
Subject Re: vacuum and postgresql.conf settings
Date
Msg-id 4672DA54.40105@steelerubber.com
Whole thread Raw
In response to Re: vacuum and postgresql.conf settings  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: vacuum and postgresql.conf settings  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: PFC
Date:
Subject: Re: Postmaster processes taking all the CPU
Next
From: MC Moisei
Date:
Subject: Re: Postmaster processes taking all the CPU