Re: Create index hanging

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Create index hanging
Дата
Msg-id 21951.1153489544@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Create index hanging  (Claire McLister <mclister@zeesource.net>)
Ответы Re: Create index hanging  (Claire McLister <mclister@zeesource.net>)
Список pgsql-general
Claire McLister <mclister@zeesource.net> writes:
> Yes, that could be the case. We have a python function that imports
> CSV files, which can take a long time, and that may have been running
> during that time. I didn't look at the pg_lock file. What should I be
> looking for?

A record with granted = false for the stuck process (joining pid to
pg_stat_activity will help you determine which process goes with each
record, or look in "ps" output).  If you find one, look for a record
for the same lock with granted = true and a conflicting lock type; that
tells you which process is blocking the lock.

            regards, tom lane

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Column info without executing query
Следующее
От: Jacob Coby
Дата:
Сообщение: Re: Column info without executing query