Re: Using an SMP machine to make multiple indices on the same table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using an SMP machine to make multiple indices on the same table
Date: 2001-10-23 03:09:26
Message-ID: 648.1003806566@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu> writes:
> On Postgresql 7.1.3, it seems that the table is locked after the
> first "create index" is started up. Is this right?

AFAIK it's a share lock, which only prohibits modifications to the
table, not reads (nor concurrent index builds). Not sure how you
expect the system to do better than that.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2001-10-23 03:15:30 Re: Database corruption?
Previous Message Bruce Momjian 2001-10-23 02:51:53 LIMIT TODO item

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2001-10-23 03:52:08 Re: Using an SMP machine to make multiple indices on the same table
Previous Message Bruce Momjian 2001-10-23 02:51:53 LIMIT TODO item