| From: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
| Cc: | 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 04:32:59 |
| Message-ID: | 20050717223259.4eca3b8c@thunder.logicalchaos.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
When grilled further on (Mon, 18 Jul 2005 00:18:43 -0400),
"Matthew T. O'Connor" <matthew(at)zeut(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2005-07-18 05:02:08 | Re: Huge performance problem between 7.4.1 and 8.0.3 - CS |
| Previous Message | Matthew T. O'Connor | 2005-07-18 04:18:43 | Re: Huge performance problem between 7.4.1 and 8.0.3 - |