X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 51225D1DC2B for ; Tue, 9 Mar 2004 04:23:14 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 04155-10 for ; Tue, 9 Mar 2004 00:23:10 -0400 (AST) Received: from ozimelb03.ozicom.com (unknown [203.185.247.97]) by svr1.postgresql.org (Postfix) with ESMTP id 1461FD1C4ED for ; Tue, 9 Mar 2004 00:23:09 -0400 (AST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Subject: ANALYZE error Date: Tue, 9 Mar 2004 15:22:51 +1100 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: ANALYZE error Thread-Index: AcQFji+nNqgzIXmDSQ+BxcOd9Fc+UA== From: "David Witham" To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/67 X-Sequence-Number: 17166 Hi all, I run a cron job at 2am every night to do an ANALYZE on my whole database: su - postgres -c 'echo analyze | /usr/bin/psql buns | grep -v ANALYZE' Its a batch oriented database so there is no user activity on it at this ti= me. The only other job that could be running is a vacuum I run at 1am but I= don't think it would take an hour to run. Occasionally I get this error me= ssage from the analyze job: ERROR: simple_heap_update: tuple concurrently updated What does this mean and should I do anything about it? Thanks, David Witham Telephony Platforms Architect Unidial Australia