X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 76E60528CF for ; Wed, 18 May 2005 13:00:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83986-07 for ; Wed, 18 May 2005 16:00:06 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 74CE352823 for ; Wed, 18 May 2005 13:00:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j4IG03lo022417; Wed, 18 May 2005 12:00:04 -0400 (EDT) To: =?ISO-8859-1?Q?K=D6PFERL_Robert?= Cc: Sql-Postgre Subject: Re: Meaning of ERROR: tuple concurrently updated In-reply-to: References: Comments: In-reply-to =?ISO-8859-1?Q?K=D6PFERL_Robert?= message dated "Wed, 18 May 2005 17:50:18 +0200" Date: Wed, 18 May 2005 12:00:03 -0400 Message-ID: <22416.1116432003@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/149 X-Sequence-Number: 21462 =?ISO-8859-1?Q?K=D6PFERL_Robert?= writes: > Thus I run VACUUM ANALYZE; every night by cron. However I keep getting > ERROR: tuple concurrently updated Have you got other processes also doing VACUUM ANALYZE? The only known reason for this to happen is that two processes concurrently ANALYZE the same table and conflict when they both try to update the same pg_statistic rows. regards, tom lane