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 12:12:52 |
Message-ID: | 3FF954C4.4060100@meerkatsoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Thanks
Alex
Doug McNaught wrote:
>Alex <alex(at)meerkatsoft(dot)com> writes:
>
>
>
>>Hi,
>>I just installed pg 7.4.1 on a new system P4, 3.2Gh HT, 1GB Mem, RH9
>>and discovered that some of the processes have become extremely
>>slow. Mainly I am talking about a SELECT COUNT(*) or VACUUM.
>>
>>Before running the same database on a P4. 2Ghz 412MB mem, I got the
>>job done in some cases half the time.
>>
>>The weird thing however is, that normal inserts seem to be much faster
>>on the new system and I am wondering if it is Postgres or HW related.
>>
>>Does anyone has an advise ?
>>
>>
>
>What kind of disk hardware is on the two systems?
>
>-Doug
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | David Garamond | 2004-01-05 13:20:30 | release notes/Appendix E in documentation |
Previous Message | Doug McNaught | 2004-01-05 11:53:48 | Re: Slow Performance with 7.4.1 |