Re: [PERFORM] Investigating IO Saturation

2006-01-24 Thread Andrew Sullivan
On Tue, Jan 24, 2006 at 02:43:59PM -0500, Chris Browne wrote: > I believe it's 7.4 where the cost-based vacuum parameters entered in, > so that would, in principle, already be an option. > > [rummaging around...] > > Hmm There was a patch for 7.4, but it's only "standard" as of > 8.0... And

Re: [PERFORM] Investigating IO Saturation

2006-01-24 Thread Chris Browne
[EMAIL PROTECTED] (Tom Lane) writes: > Brad Nicholson <[EMAIL PROTECTED]> writes: >> I'm investigating a potential IO issue. We're running 7.4 on AIX 5.1. >> During periods of high activity (reads, writes, and vacuums), we are >> seeing iostat reporting 100% disk usage. I have a feeling that

Re: [PERFORM] Investigating IO Saturation

2006-01-24 Thread Joshua D. Drake
Brad Nicholson wrote: Joshua D. Drake wrote: Brad Nicholson wrote: I'm investigating a potential IO issue. We're running 7.4 on AIX 5.1. During periods of high activity (reads, writes, and vacuums), we are seeing iostat reporting 100% disk usage. I have a feeling that the iostat numbers

Re: [PERFORM] Investigating IO Saturation

2006-01-24 Thread Tom Lane
Brad Nicholson <[EMAIL PROTECTED]> writes: > I'm investigating a potential IO issue. We're running 7.4 on AIX 5.1. > During periods of high activity (reads, writes, and vacuums), we are > seeing iostat reporting 100% disk usage. I have a feeling that the > iostat numbers are misleading. I ca

Re: [PERFORM] Investigating IO Saturation

2006-01-24 Thread Brad Nicholson
Joshua D. Drake wrote: Brad Nicholson wrote: I'm investigating a potential IO issue. We're running 7.4 on AIX 5.1. During periods of high activity (reads, writes, and vacuums), we are seeing iostat reporting 100% disk usage. I have a feeling that the iostat numbers are misleading. I can

Re: [PERFORM] Investigating IO Saturation

2006-01-24 Thread Joshua D. Drake
Brad Nicholson wrote: I'm investigating a potential IO issue. We're running 7.4 on AIX 5.1. During periods of high activity (reads, writes, and vacuums), we are seeing iostat reporting 100% disk usage. I have a feeling that the iostat numbers are misleading. I can make iostat usage jump fro

[PERFORM] Investigating IO Saturation

2006-01-24 Thread Brad Nicholson
I'm investigating a potential IO issue. We're running 7.4 on AIX 5.1. During periods of high activity (reads, writes, and vacuums), we are seeing iostat reporting 100% disk usage. I have a feeling that the iostat numbers are misleading. I can make iostat usage jump from less than 10% to gre