Re: Huge performance problem between 7.4.1 and 8.0.3 - CS - Mailing list pgsql-performance

From Robert Creager
Subject Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Date
Msg-id 20050718000713.3366dad9@thunder.logicalchaos.org
Whole thread Raw
In response to Re: Huge performance problem between 7.4.1 and 8.0.3 - CS  (Robert Creager <Robert_Creager@LogicalChaos.org>)
List pgsql-performance
When grilled further on (Sun, 17 Jul 2005 23:43:29 -0600),
Robert Creager <Robert_Creager@LogicalChaos.org> confessed:

> I've 6 runs going concurrently.  Just saw (vmstat 1) a set of 8 seconds where
> the CS didn't drop below 90k, but right now its at ~300 for over 30 seconds...

> It's bouncing all over the place, but staying reasonably well behaved overall.
>

Against 741 and the same load, CS is steady around 300 with spikes up to 4k, but
it's only been running for about 15 minutes.  All queries are < .2 seconds.

Cheers,
Rob

--
 00:03:33 up 4 days,  3:38,  6 users,  load average: 1.67, 0.98, 0.44
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

Attachment

pgsql-performance by date:

Previous
From: Robert Creager
Date:
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Next
From: Dawid Kuroczko
Date:
Subject: Re: slow joining very large table to smaller ones