X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 82DF29DCA43 for ; Thu, 22 Dec 2005 16:58:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 53305-07 for ; Thu, 22 Dec 2005 16:58:22 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.195]) by postgresql.org (Postfix) with ESMTP id 2C19C9DC8D9 for ; Thu, 22 Dec 2005 16:58:18 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i3so446960wra for ; Thu, 22 Dec 2005 12:58:21 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=uU1nvUXh4qd54ovzjHbQEkegjSICcON5M9UsYhOLwx80PkmCZOWzFh9R2BA3r3JIz4GjQZJWFrXK5UXkKhUrSiLKxR0kExvVGilN+BcAyv4ch9gUsZHMJTV9aAn3n3fEp6Yey78zp1Ljrsj0cpoULgwhEbOVYN0u7dBmj06betI= Received: by 10.65.232.11 with SMTP id j11mr1207118qbr; Thu, 22 Dec 2005 12:58:20 -0800 (PST) Received: by 10.65.160.11 with HTTP; Thu, 22 Dec 2005 12:58:20 -0800 (PST) Message-ID: Date: Fri, 23 Dec 2005 09:58:20 +1300 From: Mike C To: pgsql-admin@postgresql.org Subject: Create Index Locking Question MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13755_10605858.1135285100709" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.081 required=5 tests=[AWL=0.080, HTML_MESSAGE=0.001] X-Spam-Score: 0.081 X-Spam-Level: X-Archive-Number: 200512/278 X-Sequence-Number: 19998 ------=_Part_13755_10605858.1135285100709 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I need to create a new index on an existing table. The table is constantly inserted into every second. Does CREATE INDEX require an exclusive write lock on the table? If it does have a write lock what happens to the insert statements at the time, are they simply played later or do they fail?