Re: vacuum and postgresql.conf settings

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Walter Vaughan <wvaughan(at)steelerubber(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum and postgresql.conf settings
Date: 2007-06-15 18:35:41
Message-ID: cone.1181932541.733860.53974.5001@35st.simplicato.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Walter Vaughan writes:

> 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?

I don't know. Hopefully others with more knowledge can answer.

I think it could be because the pages did not need to be looked at.
Perhaps the database tracks whether a page has deleted information and those
are the ones that vacuum looks into.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-06-15 18:43:47 Re: vacuum and postgresql.conf settings
Previous Message Mark Soper 2007-06-15 18:31:41 Dynamically generating DDL for postgresql object