Re: [ADMIN] High IOWAIT times, low iops? Can't figure out what the bottleneck is...

2007-07-03 Thread Evan Reiser
index on id + a non clustered index on done,failed,invalid + a non clustered index on lockedby There are no triggers On 7/3/07, Evan Reiser <[EMAIL PROTECTED]> wrote: I was wondering if you guys have some suggested settings for our server, i think we are not hardware limited b

[ADMIN] High IOWAIT times, low iops? Can't figure out what the bottleneck is...

2007-07-03 Thread Evan Reiser
ay = 20ms fsync = on wal_buffers = 1MB checkpoint_segments = 32 effective_cache_size = 4128MB If you guys have any suggestions it would be greatly appreciated -Evan Reiser