> I have the native Windows version of postgres installed now. It is > still very slow. I did a `select * from dbmail_messageblks` and it > lasts about two minutes to fetch 100 rows! This is very slow, and I > don't think that the Cygwin version is much slower here. Why is this > so slow?
That is not normal behaviour, are you sure your harddrive is running in udma mode and not pio-0 or similar dog-slow mode? http://www.simplisoftware.com/Public/index.php?request=HdTach You can verify the disk speed with this program. Example output of good drive: http://mirror.circlestorm.org/hdspeed.png Note though that thatone is of my 15krpm scsi disk. You should be able to do 60MB/sec with a fairly new disk. If yours is anywhere below ~20, either you have a disk from the last millenium or you have some bios/cable/windows/driver error. -=Dead2=-
