Re: Multiple index builds on same table - in one sweep?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Multiple index builds on same table - in one sweep?
Дата
Msg-id 6692.1302547143@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Multiple index builds on same table - in one sweep?  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Multiple index builds on same table - in one sweep?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Mon, Apr 11, 2011 at 1:41 AM, Greg Smith <greg@2ndquadrant.com> wrote:
>> Scott Marlowe wrote:
>>> FYI, in 8.3.13 I get this for all but one index:
>>> ERROR: �deadlock detected

>> Is that trying to build them by hand? �The upthread request here is actually
>> already on the TODO list at http://wiki.postgresql.org/wiki/Todo and it
>> talks a bit about what works and what doesn't right now:

> Yes, by hand.  It creates an entry for the index but lists but marks
> it as INVALID

Are you trying to use CREATE INDEX CONCURRENTLY?  AFAIR that doesn't
support multiple index creations at the same time.  Usually you wouldn't
want that combination anyway, since the point of CREATE INDEX
CONCURRENTLY is to not prevent foreground use of the table while you're
making the index --- and multiple index creations are probably going to
eat enough I/O that you shouldn't be doing them during normal operations
anyhow.

Just use plain CREATE INDEX.

            regards, tom lane

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Linux: more cores = less concurrency.
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Multiple index builds on same table - in one sweep?