pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCreate Index Locking Question
2+ messages / 2 participants
[nested] [flat]
* Create Index Locking Question
@ 2005-12-22 20:58 Mike C <smith.not.western@gmail.com>
2005-12-22 23:21 ` Re: Create Index Locking Question Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Mike C @ 2005-12-22 20:58 UTC (permalink / raw)
To: 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?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Create Index Locking Question
2005-12-22 20:58 Create Index Locking Question Mike C <smith.not.western@gmail.com>
@ 2005-12-22 23:21 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2005-12-22 23:21 UTC (permalink / raw)
To: Mike C <smith.not.western@gmail.com>; +Cc: pgsql-admin
Mike C <smith.not.western@gmail.com> writes:
> 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?
The inserting transactions are blocked until the CREATE INDEX is done.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-12-22 23:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-22 20:58 Create Index Locking Question Mike C <smith.not.western@gmail.com>
2005-12-22 23:21 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox