Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> What is the advantage of delaying vacuum per page vs. just doing vacuum
> less frequently?
The point is the amount of load VACUUM poses while it's running. If
your setup doesn't have a lot of disk bandwidth to spare, a background
VACUUM can hurt the performance of your foreground applications quite
a bit. Running it less often doesn't improve this issue at all.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2003-10-31 17:21:52|
|Subject: Re: PQunescapeBytea code |
|Previous:||From: Tom Lane||Date: 2003-10-31 17:02:57|
|Subject: Re: Call for port reports |