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
pgpyW2YS2xW5q.pgp
Description: PGP signature