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 11:53:48
Message-ID: 87n0927gs3.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex 2004-01-05 12:12:52 Re: Slow Performance with 7.4.1
Previous Message Chris Travers 2004-01-05 10:16:23 Re: History-based (or logged) database.