X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A6C675E4885 for ; Mon, 6 Sep 2004 02:19:35 +0100 (BST) 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 04783-02 for ; Mon, 6 Sep 2004 01:19:34 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.200]) by svr1.postgresql.org (Postfix) with ESMTP id B37595E48BB for ; Mon, 6 Sep 2004 02:19:31 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 73so144015rnk for ; Sun, 05 Sep 2004 18:19:35 -0700 (PDT) Received: by 10.38.24.70 with SMTP id 70mr1147607rnx; Sun, 05 Sep 2004 18:19:35 -0700 (PDT) Received: by 10.38.165.47 with HTTP; Sun, 5 Sep 2004 18:19:35 -0700 (PDT) Message-ID: Date: Sun, 5 Sep 2004 20:19:35 -0500 From: Kevin Barnard Reply-To: Kevin Barnard To: pgsql-performance@postgresql.org Subject: Re: Table UPDATE is too slow In-Reply-To: <413BA104.1040508@geizhals.at> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable References: <4134BF36.3000504@syscor.com> <413BA104.1040508@geizhals.at> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/33 X-Sequence-Number: 8161 Do all of the commands to swap tables in a transaction. =A0The table gets locked briefly but should have a lot less impact then the update command. On Mon, 06 Sep 2004 01:28:04 +0200, Marinos J. Yannikos w= rote: >=20 > That said, I'm not entirely sure how well postgres' client libraries can > deal with tables being renamed while in use, perhaps someone can shed > some light on this. >