From: | Mike C <smith(dot)not(dot)western(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Create Index Locking Question |
Date: | 2005-12-22 20:58:20 |
Message-ID: | bd0eabd0512221258y58b1f42fy8cfae304baffd8e7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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?
From http://www.postgresql.org/docs/8.1/interactive/sql-reindex.html I see
CREATE INDEX apparently requires a write lock, but I'm not 100% certain
because the CREATE INDEX was used to describe part of the REINDEX command.
The CREATE INDEX page makes no mention of locking issues:
http://www.postgresql.org/docs/8.1/interactive/sql-createindex.html
Could someone please clarify for me: Will I lose the INSERT statements
performed while a CREATE INDEX is running?
Regards,
Mike C.
From | Date | Subject | |
---|---|---|---|
Next Message | Mike C | 2005-12-22 21:09:28 | Re: WAL and pg_dump |
Previous Message | Alain Rodriguez Arias | 2005-12-22 18:35:43 | lo_ functions |