From: | Alex <alex(at)meerkatsoft(dot)com> |
---|---|
To: | Doug McNaught <doug(at)mcnaught(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Slow Performance with 7.4.1 |
Date: | 2004-01-05 15:50:05 |
Message-ID: | 3FF987AD.4090101@meerkatsoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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(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
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2004-01-05 15:51:34 | Re: [HACKERS] Announce: Search PostgreSQL related resources |
Previous Message | Alex J. Avriette | 2004-01-05 15:45:34 | Re: psql \d option list overloaded |