Re: Index creation problem

Поиск
Список
Период
Сортировка
От Oliver Kohll - Mailing Lists
Тема Re: Index creation problem
Дата
Msg-id A655178E-E20C-41FD-B4C6-B11AD3E03286@gtwm.co.uk
обсуждение исходный текст
Ответ на Re: Index creation problem  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general

On 19 Oct 2012, at 15:09, "Albe Laurenz" <laurenz.albe@wien.gv.at> wrote:

You should always include the list in your replies -
other people might be interested in the solution.

Oops, thought I had.


There must be at least two transactions involved
to create a locking problem like you describe.
But since CREATE INDEX takes strong locks, it can
easily get locked by other "harmless" things.

OK, I've reduced the calls to CREATE INDEX, waiting to test that. If there's still an issue I will use CONCURRENTLY as you suggested.

Many thanks
Oliver

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

Предыдущее
От: GMAIL
Дата:
Сообщение: Re: Multiple Cluster on same host
Следующее
От: Shaun Thomas
Дата:
Сообщение: Re: Multiple Cluster on same host