| From: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
|---|---|
| To: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, PGPerformance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Huge performance problem between 7.4.1 and 8.0.3 - CS |
| Date: | 2005-07-18 06:07:13 |
| Message-ID: | 20050718000713.3366dad9@thunder.logicalchaos.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
When grilled further on (Sun, 17 Jul 2005 23:43:29 -0600),
Robert Creager <Robert_Creager(at)LogicalChaos(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dawid Kuroczko | 2005-07-18 07:51:41 | Re: slow joining very large table to smaller ones |
| Previous Message | Robert Creager | 2005-07-18 05:56:30 | Re: Huge performance problem between 7.4.1 and 8.0.3 - CS |