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 20050717223259.4eca3b8c@thunder.logicalchaos.org
Whole thread Raw
In response to Re: Huge performance problem between 7.4.1 and 8.0.3 -  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-performance
When grilled further on (Mon, 18 Jul 2005 00:18:43 -0400),
"Matthew T. O'Connor" <matthew@zeut.net> confessed:

> Have you turned on the query logging to see what queries are
> taking so long?
>

Yeah.  In the original message is a typical query.  One from 741 and the other
on 803.  On 803, an explain analyze is done twice.  Once during the problem,
once when the system is idle.  On 741, the query behaves the same no matter
what...

Cheers,
Rob

--
 22:31:18 up 4 days,  2:06,  8 users,  load average: 0.25, 0.18, 0.11
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

Attachment

pgsql-performance by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 -
Next
From: Robert Creager
Date:
Subject: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS