| From: | Wes <wespvp(at)syntegra(dot)com> |
|---|---|
| To: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Concurrency problem building indexes |
| Date: | 2006-04-23 14:06:59 |
| Message-ID: | C070F433.23911%wespvp@syntegra.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
<http://archives.postgresql.org/pgsql-hackers/2002-07/msg00969.php>
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2006-04-23 14:15:56 | Re: Automatically assuming a specific role after connecting to pg |
| Previous Message | Florian G. Pflug | 2006-04-23 13:46:42 | Re: Automatically assuming a specific role after connecting |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2006-04-23 15:06:30 | Re: TODO items.. |
| Previous Message | Gevik Babakhani | 2006-04-23 09:04:27 | Question about dependency functions in the backend |