Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 41B45640AAC for ; Thu, 16 Apr 2009 03:41:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 85004-01-3 for ; Thu, 16 Apr 2009 03:41:21 -0300 (ADT) Received: from pgfoundry.org (pgfoundry.org [200.46.204.130]) by mail.postgresql.org (Postfix) with ESMTP id 779F463F14C for ; Thu, 16 Apr 2009 03:01:53 -0300 (ADT) Received: from localhost (maia-1.hub.org [200.46.208.211]) by pgfoundry.org (Postfix) with ESMTP id 102E317ADEFB for ; Thu, 16 Apr 2009 06:01:53 +0000 (UTC) Received: from pgfoundry.org ([200.46.204.130]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 58031-03 for ; Thu, 16 Apr 2009 03:01:29 -0300 (ADT) Received: by pgfoundry.org (Postfix, from userid 1357) id D8B2917ADEEE; Thu, 16 Apr 2009 06:01:03 +0000 (UTC) MIME-Version: 1.0 To: pgsql-committers@postgresql.org Subject: reorg - pg_reorg: Modify LOCK to LOCK-NOWAIT-and-loop at swap tables to X-Mailer: activitymail 1.19, http://search.cpan.org/dist/activitymail/ X-PgFoundry: reorg - Content-Type: text/plain Message-Id: <20090416060103.D8B2917ADEEE@pgfoundry.org> Date: Thu, 16 Apr 2009 06:01:03 +0000 (UTC) From: itagaki@pgfoundry.org (User Itagaki) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200904/200 X-Sequence-Number: 36694 Log Message: ----------- Modify LOCK to LOCK-NOWAIT-and-loop at swap tables to avoid holding exclusive locks long time. Suggested by Kenny Gorman. Modified Files: -------------- pg_reorg/bin: pg_reorg.c (r1.4 -> r1.5) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/bin/pg_reorg.c.diff?r1=1.4&r2=1.5) pg_reorg/doc: index-ja.html (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/doc/index-ja.html.diff?r1=1.2&r2=1.3) index.html (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/doc/index.html.diff?r1=1.2&r2=1.3) pg_reorg-ja.html (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/doc/pg_reorg-ja.html.diff?r1=1.2&r2=1.3) pg_reorg.html (r1.2 -> r1.3) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/doc/pg_reorg.html.diff?r1=1.2&r2=1.3) pg_reorg/lib: pg_reorg.sql.in (r1.3 -> r1.4) (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/lib/pg_reorg.sql.in.diff?r1=1.3&r2=1.4)