Re: Vacuum Looping 7.4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: elein(at)varlena(dot)com (elein)
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Vacuum Looping 7.4
Date: 2005-01-25 21:41:57
Message-ID: 7096.1106689317@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

elein(at)varlena(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Fuhr 2005-01-25 21:46:48 Re: [HACKERS] RQ: Prepared statements used by multiple connections
Previous Message Tom Lane 2005-01-25 21:22:25 Re: [HACKERS] userlock changes for 8.1/8.2