dbTalk Databases Forums  

Vacuum message

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss Vacuum message in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kevin Barnard
 
Posts: n/a

Default Vacuum message - 11-11-2004 , 08:23 AM






I know I've seen this message before but I'm not quite sure what it
means. I think it's because I have two vacuums running over each
other. Does this sound right? It's comming from 7.4.x server.

ERROR: tuple concurrently updated

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


Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: Vacuum message - 11-11-2004 , 12:56 PM






Kevin Barnard <kevin.barnard (AT) gmail (DOT) com> writes:
Quote:
I know I've seen this message before but I'm not quite sure what it
means. I think it's because I have two vacuums running over each
other. Does this sound right? It's comming from 7.4.x server.

ERROR: tuple concurrently updated
Were they both VACUUM ANALYZEs? There's a known gotcha that if you
ANALYZE the same table concurrently in two different sessions, one
of them can fail this way when it goes to update the pg_statistic
entries. (Harmless, but annoying.) I don't know of any cause for
this message from a plain VACUUM though.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match



Reply With Quote
  #3  
Old   
Kevin Barnard
 
Posts: n/a

Default Re: Vacuum message - 11-11-2004 , 05:25 PM



On Thu, 11 Nov 2004 13:56:48 -0500, Tom Lane <tgl (AT) sss (DOT) pgh.pa.us> wrote:
Quote:
Were they both VACUUM ANALYZEs? There's a known gotcha that if you
ANALYZE the same table concurrently in two different sessions, one
of them can fail this way when it goes to update the pg_statistic
entries. (Harmless, but annoying.) I don't know of any cause for
this message from a plain VACUUM though.

regards, tom lane

That's what it is I have cron jobs running over each other during heavy load.

Thanks

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.