Re: Slow Performance with 7.4.1
Alex <alex@meerkatsoft.com>
From: Alex <alex@meerkatsoft.com>
To: Doug McNaught <doug@mcnaught.org>
Cc: pgsql-general@postgresql.org
Date: 2004-01-05T15:50:05Z
Lists: pgsql-general
Yup, DMA is not enabled, probably that is the problem. Tried to enable it but get an error HDIO_SET_DMA failed: Operation not permitted. Thanks for the hint. Alex Doug McNaught wrote: >Alex <alex@meerkatsoft.com> writes: > > > >>The old system has a 80GB, 5200rpm ATA , the new system a 120GB, >>7200rpm ATA. The new system should at least not be slower. Also, on >>the new system I have a separate partition for the database. >> >>If I run a Vacuum or a SELECT COUNT(*) on a larger table (2-6 million >>records) the systems responds very slow, the screen almost freezes. >> >> > >Sounds like you may not have DMA enabled on the newer machine, or >there is some other kernel problem that slows the disk down. You >might try running Bonnie or a similar disk benchmark to make sure you >are getting the right disk performance. > >-Doug > > > >