Re: Slow Performance with 7.4.1

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Alex <alex(at)meerkatsoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow Performance with 7.4.1
Date: 2004-01-05 13:44:17
Message-ID: 87hdza7bny.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alex <alex(at)meerkatsoft(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jiri D. Hoogeveen 2004-01-05 14:17:15 unsubscribe
Previous Message Paul Ganainm 2004-01-05 13:39:00 Re: Is my MySQL Gaining ?