Re: Slow Performance with 7.4.1 - Mailing list pgsql-general

From Doug McNaught
Subject Re: Slow Performance with 7.4.1
Date
Msg-id 87hdza7bny.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: Slow Performance with 7.4.1  (Alex <alex@meerkatsoft.com>)
Responses unsubscribe  ("Jiri D. Hoogeveen" <jiri@pro.nl>)
Re: Slow Performance with 7.4.1  (Alex <alex@meerkatsoft.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Paul Ganainm
Date:
Subject: Re: Is my MySQL Gaining ?
Next
From: "Jiri D. Hoogeveen"
Date:
Subject: unsubscribe