Re: Vacuum Looping 7.4 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vacuum Looping 7.4
Date
Msg-id 7096.1106689317@sss.pgh.pa.us
Whole thread Raw
In response to Vacuum Looping 7.4  (elein@varlena.com (elein))
List pgsql-hackers
elein@varlena.com (elein) writes:
> Our vacuum mem is very high.

Define "very high".  I'm wondering if it's too high, as in large enough
to overflow an int when multiplied by 1K.  It looks to me like the thing
is cleaning indexes after traversing each individual heap page, which it
would not do unless it thought it had filled up vacuum_mem.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: userlock changes for 8.1/8.2
Next
From: Michael Fuhr
Date:
Subject: Re: RQ: Prepared statements used by multiple connections