Slow Performance with 7.4.1

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Slow Performance with 7.4.1
Date: 2004-01-05 08:24:41
Message-ID: 3FF91F49.1020403@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanks
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2004-01-05 08:27:42 Re: Mnogosearch (Was: Re: website doc search is ... )
Previous Message Oleg Bartunov 2004-01-05 08:23:59 Re: website doc search is extremely SLOW