Re: vacuum locking

From: Rob Nagler <nagler(at)bivio(dot)biz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: vacuum locking
Date: 2003-10-24 22:04:39
Message-ID: 16281.41463.449000.639113@gargle.gargle.HOWL
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Stephen writes:
> I ran into the same problem with VACUUM on my Linux box. If you are running
> Linux, take a look at "elvtune" or read this post:

The default values were -r 64 -w 8192. The article said this was
"optimal". I just futzed with different values anywere from -w 128 -r
128 to -r 16 -w 8192. None of these mattered much when vacuum is
running.

This is a RAID1 box with two disks. Even with vacuum and one other
postmaster running, it's still got to get a lot of blocks through the
I/O system.

Rob

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rob Nagler 2003-10-24 22:07:25 Re: vacuum locking
Previous Message Richard Jones 2003-10-24 21:06:10 Memcache