Mike C <smith.not.western@xxxxxxxxx> 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
