Re: [PERFORM] blocking index creation

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: [PERFORM] blocking index creation
Дата
Msg-id 1507729579.2627.13.camel@cybertec.at
обсуждение исходный текст
Ответ на [PERFORM] blocking index creation  (Neto pr <netopr9@gmail.com>)
Ответы Re: [PERFORM] blocking index creation  (Neto pr <netopr9@gmail.com>)
Список pgsql-performance
Neto pr wrote:
> When creating index on table of approximately 10GB of data, the DBMS hangs (I think),
> because even after waiting 10 hours there was no return of the command.
> It happened by creating Hash indexes and B + tree indexes.
> However, for some columns, it was successfully (L_RETURNFLAG, L_PARTKEY).

> If someone has a hint how to speed up index creation so that it completes successfully.

Look if CREATE INDEX is running or waiting for a lock (check the
"pg_locks" table, see if the backend consumes CPU time).

Maybe there is a long-running transaction that blocks the
ACCESS EXCLUSIVE lock required.  It could also be a prepared
transaction.

Yours,
Laurenz Albe


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: Neto pr
Дата:
Сообщение: [PERFORM] blocking index creation
Следующее
От: Purav Chovatia
Дата:
Сообщение: Re: [PERFORM] Stored Procedure Performance