Re: Huge performance problem between 7.4.1 and 8.0.3 - CS

From: Robert Creager <Robert_Creager(at)LogicalChaos(dot)org>
To: David Mitchell <david(dot)mitchell(at)telogis(dot)com>
Cc: "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 05:02:08
Message-ID: 20050717230208.6b6c319d@thunder.logicalchaos.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

When grilled further on (Mon, 18 Jul 2005 16:17:54 +1200),
David Mitchell <david(dot)mitchell(at)telogis(dot)com> confessed:

> Maybe you should check who is holding locks.

Hmmm... The only difference is how the vacuum is run. One by autovacuum, one
by cron (vacuum analyze every 5 minutes).

Cheers,
Rob

--
23:01:44 up 4 days, 2:36, 6 users, load average: 0.27, 0.16, 0.10
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeffrey W. Baker 2005-07-18 05:09:11 Re: Huge performance problem between 7.4.1 and 8.0.3 -
Previous Message Robert Creager 2005-07-18 04:32:59 Re: Huge performance problem between 7.4.1 and 8.0.3 - CS