From: David Witham <davidw@unidial.com.au>
To: pgsql-sql@postgresql.org
Subject: ANALYZE error
Date: Tue, 9 Mar 2004 15:22:51 +1100
Message-ID: <CFA248776934FD43847E740E43C346D199DC67@ozimelb03.ozicom.com> (raw)
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 time. 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 message 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: davidw@unidial.com.au
Subject: Re: ANALYZE error
In-Reply-To: <CFA248776934FD43847E740E43C346D199DC67@ozimelb03.ozicom.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox