CIC and deadlocks
От | Pavan Deolasee |
---|---|
Тема | CIC and deadlocks |
Дата | |
Msg-id | 2e78013d0703310515v443153efi49da147cc59780c7@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: CIC and deadlocks
Re: CIC and deadlocks |
Список | pgsql-hackers |
<br />Isn't CREATE INDEX CONCURRENTLY prone deadlock conditions ?<br />I saw one with VACUUM today. But I think it can happenwith other<br />commands like VACUUM FULL, CLUSTER, CREATE INDEX<br />CONCURRENTLY and so on. These commands conflicton the <br />ShareUpdateExclusiveLock held by CIC and hence would wait for<br />CIC to release the lock. At the sametime, CIC would wait for these<br />transactions to complete.<br clear="all" /><br />We know that these commands arerun in a separate transaction <br />and do not do any index fetches or inserts/updates. So in principle<br />CIC neednot wait for these transactions to complete in any<br />of its waits. May be we can skip waits on the transactions that<br/>are running one of these commands. <br /><br />Is it something worth doing ?<br /><br />Thanks,<br />Pavan<br /><br/>-- <br /><br />EnterpriseDB <a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a>
В списке pgsql-hackers по дате отправления: