Re: problems with new vacuum (??) - Mailing list pgsql-hackers

From Don Baccus
Subject Re: problems with new vacuum (??)
Date
Msg-id 3C3352BB.5020008@pacifier.com
Whole thread Raw
In response to Re: problems with new vacuum (??)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: problems with new vacuum (??)
List pgsql-hackers
Bruce Momjian wrote:

>>In my experience enabling this feature can make a huge improvement in I/O 
>>intensive applications.  Other options can help also, but I find dma to have 
>>the largest impact.  I find linux almost unusable without it.
>>
> 
> Oh, I should mention my BSD/OS data point is with one SCSI disk, soft
> updates and tagged queuing enabled.


If Tom's system is IDE-based and he's not explicitly enabled DMA then 
this alone would explain the difference you two are seeing, just as the 
poster above is implying.  I have one system with an older 15GB disk 
that causes a kernel panic if I try to enable DMA, and I see the kind of 
system performance issues described by Tom on that system.

On my main server downtown (SCSI) and my normal desktop (two IDE drives 
that do work properly with DMA enabled) things run much, much better 
when there's a lot of disk I/O going on.  These are all Linux systems, 
not BSD...


-- 
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org



pgsql-hackers by date:

Previous
From: Holger Krug
Date:
Subject: Re: Feature proposal: generalizing deferred trigger events
Next
From: Tom Lane
Date:
Subject: Re: problems with new vacuum (??)