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

From Tom Lane
Subject Re: problems with new vacuum (??)
Date
Msg-id 5435.1009996832@sss.pgh.pa.us
Whole thread Raw
In response to Re: problems with new vacuum (??)  (Don Baccus <dhogaza@pacifier.com>)
List pgsql-hackers
Don Baccus <dhogaza@pacifier.com> writes:
> 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,

It is IDE, but DMA is on:

[root@rh1 root]# hdparm -v /dev/hda

/dev/hda:multcount    = 16 (on)I/O support  =  0 (default 16-bit)unmaskirq    =  0 (off)using_dma    =  1
(on)keepsettings=  0 (off)nowerr       =  0 (off)readonly     =  0 (off)readahead    =  8 (on)geometry     =
9729/255/63,sectors = 156301488, start = 0
 

[root@rh1 root]# hdparm -i /dev/hda

/dev/hda:
Model=ST380021A, FwRev=3.10, SerialNo=3HV0CZ2LConfig={ HardSect NotMFM HdSw>15uSec Fixed DTR>10Mbs RotSpdTol>.5%
}RawCHS=16383/16/63,TrkSize=0, SectSize=0, ECCbytes=4BuffType=unknown, BuffSize=2048kB, MaxMultSect=16,
MultSect=16CurCHS=16383/16/63,CurSects=-66060037, LBA=yes, LBAsects=156301488IORDY=on/off, tPIO={min:240,w/IORDY:120},
tDMA={min:120,rec:120}PIOmodes: pio0 pio1 pio2 pio3 pio4DMA modes: mdma0 mdma1 mdma2 udma0 udma1 udma2 udma3 udma4
*udma5AdvancedPM=noDriveSupports : Reserved : ATA-1 ATA-2 ATA-3 ATA-4 ATA-5
 

This is an out-of-the-box RH 7.2 install (kernel 2.4.7-10) on recent
Dell hardware.  If anyone can suggest further tuning of the hdparm
settings, I'm all ears.  Don't know a darn thing about disk tuning
for Linux.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: problems with new vacuum (??)
Next
From: Bruce Momjian
Date:
Subject: Re: Bulkloading using COPY - ignore duplicates?