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

From Alex
Subject Re: Slow Performance with 7.4.1
Date
Msg-id 3FF987AD.4090101@meerkatsoft.com
Whole thread Raw
In response to Re: Slow Performance with 7.4.1  (Doug McNaught <doug@mcnaught.org>)
Responses Re: Slow Performance with 7.4.1  (Thomas Beutin <tyrone@laokoon.IN-Berlin.DE>)
List 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
>
>
>
>



pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Announce: Search PostgreSQL related resources
Next
From: Dave Cramer
Date:
Subject: Re: [HACKERS] Announce: Search PostgreSQL related resources