Skip site navigation (1) Skip section navigation (2)

Re: problems with new vacuum (??)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Don Baccus <dhogaza(at)pacifier(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Barry Lind <barry(at)xythos(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: problems with new vacuum (??)
Date: 2002-01-02 18:40:32
Message-ID: 5435.1009996832@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Don Baccus <dhogaza(at)pacifier(dot)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(at)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(at)rh1 root]# hdparm -i /dev/hda

/dev/hda:

 Model=ST380021A, FwRev=3.10, SerialNo=3HV0CZ2L
 Config={ HardSect NotMFM HdSw>15uSec Fixed DTR>10Mbs RotSpdTol>.5% }
 RawCHS=16383/16/63, TrkSize=0, SectSize=0, ECCbytes=4
 BuffType=unknown, BuffSize=2048kB, MaxMultSect=16, MultSect=16
 CurCHS=16383/16/63, CurSects=-66060037, LBA=yes, LBAsects=156301488
 IORDY=on/off, tPIO={min:240,w/IORDY:120}, tDMA={min:120,rec:120}
 PIO modes: pio0 pio1 pio2 pio3 pio4
 DMA modes: mdma0 mdma1 mdma2 udma0 udma1 udma2 udma3 udma4 *udma5
 AdvancedPM=no
 Drive Supports : 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

In response to

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2002-01-02 21:09:14
Subject: Re: problems with new vacuum (??)
Previous:From: Don BaccusDate: 2002-01-02 18:34:35
Subject: Re: problems with new vacuum (??)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group