Re: vacuum and postgresql.conf settings

From: Walter Vaughan <wvaughan(at)steelerubber(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum and postgresql.conf settings
Date: 2007-06-15 18:28:36
Message-ID: 4672DA54.40105@steelerubber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message MC Moisei 2007-06-15 18:30:26 Re: Postmaster processes taking all the CPU
Previous Message PFC 2007-06-15 18:03:08 Re: Postmaster processes taking all the CPU