By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,104 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

question about error message

P: n/a
I got an error doing a vacuum analyze on one of our table:

MSG: 7 (S1000): ERROR: simple_heap_update: tuple concurrently updated

does anyone know what this means, and more importantly... should i be
worried about this?

i'm running 7.3.2 on redhat 7.3 dual 1.8 xeon with 1gb ram.

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Brian Hirt wrote:
I got an error doing a vacuum analyze on one of our table:

MSG: 7 (S1000): ERROR: simple_heap_update: tuple concurrently updated

does anyone know what this means, and more importantly... should i be
worried about this?


Are you by chance running analyze concurrently?

At
http://developer.postgresql.org/cvsw....12&sortby=log
I see this:

Revision 1.42 / (download) - annotate - [select for diffs] , Sun Aug 11
00:08:48 2002 UTC (15 months, 1 week ago) by tgl
Changes since 1.41: +13 -10 lines
Diff to previous 1.41 to selected 1.12

Now that we allow ANALYZE to run inside a transaction block, the locks
it takes could be held for quite awhile after the analyze step completes.
Rethink locking of pg_statistic in light of this fact. The original
scheme took an exclusive lock on pg_statistic, which was okay when the
lock could be expected to be released shortly, but that doesn't hold
anymore. Back off to a normal writer's lock (RowExclusiveLock). This
allows concurrent ANALYZE of nonoverlapping sets of tables, at the price
that concurrent ANALYZEs of the same table may fail with 'tuple
concurrently updated'.

HTH,

Joe
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.