Re[4]: Postgres is too slow?

AP> Questions:
AP> a) which linux kernel version is it?
AP> b) what kind of a disk is it? IDE or SCSI?
AP> c) what raw speed do you from the disk? do
AP> 'time dd if=/dev/hdxxx of=/dev/null bs=64k count=10000'

HDD is IDE - Quantum lct10, 5400 rpm - yes, it's slow.
But I compared with MSSQL on the same PC with the same HDD...

# cat </proc/version
Linux version 2.2.16 (root@pm) (gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)) #5 Thu Dec 7 15:34:44
YEKT2000 

# time dd if=/dev/hda3 of=/dev/null bs=64k count=10000
 10000+0 records in
 10000+0 records out

 real    3m33.731s
 user    0m0.020s
 sys     2m37.960s

#  hdparm /dev/hda

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

# cat /proc/sys/fs/file-max
4096

# ipcs -l -s

------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767

# ipcs -l -m

------ Shared Memory Limits --------
max number of segments = 128
max seg size (kbytes) = 131072
max total shared memory (kbytes) = 16777216
min seg size (bytes) = 1


Posmaster runned as:
$ postmaster -B 8000 -D /sql/data

vmstat's results during my SQL request
# vmstat
   procs                      memory    swap          io     system         cpu
 r  b  w   swpd   free   buff  cache  si  so    bi    bo   in    cs  us  sy  id
 1  0  0      0   2036  68216  23652   0   0   199     2 1712    44   1  22  78

--
Best regards,
 Paul                            mailto:magamos@mail.ru