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