Slow Performance with 7.4.1
Alex <alex@meerkatsoft.com>
From: Alex <alex@meerkatsoft.com>
To: pgsql-general@postgresql.org
Date: 2004-01-05T08:24:41Z
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