create index concurrently blocked by other query

Поиск
Список
Период
Сортировка
От James Pang
Тема create index concurrently blocked by other query
Дата
Msg-id CAHgTRfcE-LifnO81E2dTK4dKiUcSjqG0U=Gs5T_zAH=jUxJqGw@mail.gmail.com
обсуждение исходный текст
Ответы Re: create index concurrently blocked by other query
Re: create index concurrently blocked by other query
Список pgsql-admin
Hi,
    PGv14, it's a time range partition table, we first create index ... on ONLY parent table and it's done very fast, then we are doing "create index concurrently ... on  each partition table", then we saw it blocked by some other sessopm  "select on other tables" , is it expected ? 
   from pg_locks, and pg_stat_activity : 
for this relation we are creating index concurrently, only "access share" lock by other sessions:

blocked pid 512694:
blocked query: CREATE INDEX CONCURRENTLY IF NOT EXISTS IDX_XMEETINGMETADATA_P202401_xxxID ON xxxxxx_P202401(xxID,SssID); | 

blocking pid 90252 
blocking query: it's a select from other tables not the one we are creating index concurrently..
 SELECT m.Meetingxxx mxxxKey, m.MTGxxxx....,
                                                                            +
             |              |              |               |
                           

Thanks,

James 

В списке pgsql-admin по дате отправления:

Предыдущее
От: Bindra Bambharoliya
Дата:
Сообщение: Cursor with hold for select
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Cursor with hold for select