Re: [GENERAL] Concurrency problem building indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Wes <wespvp(at)syntegra(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Concurrency problem building indexes
Date: 2006-04-25 00:42:41
Message-ID: 7980.1145925761@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> Was the code ever changed so that it won't update relpages if the number
> is the same?

Long ago. I just tested it again, and AFAICS you can create indexes
concurrently so long as the underlying table isn't changing (ie,
neither reltuples nor relpages changes).

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-04-25 00:54:47 Re: [GENERAL] Concurrency problem building indexes
Previous Message Jim C. Nasby 2006-04-25 00:19:06 Re: [GENERAL] Concurrency problem building indexes

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2006-04-25 00:54:47 Re: [GENERAL] Concurrency problem building indexes
Previous Message Bruce Momjian 2006-04-25 00:25:05 Re: Additional current timestamp values