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 <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
