Concurrency problem building indexes
Concurrency problem building indexes
От:
Wes <wespvp@syntegra.com>
Дата:
Postgres: 8.1.3 OS: Mac OS X 10.4.6 I've run into another concurrency issue - parallel building of indexes. When I try to build multiple indexes at a time, I randomly get: ERROR: tuple concurrently updated The following thread talks about this, but there is no answer. How can I safely build indexes in parallel? At this point, I'm only trying to build two at a time. I will be building indexes for tables with any where from a few rows to 100 million rows on a daily basis - I need to maximize performance. Wes