Postgres Pro
Downloads
Home   >   mailing lists

Re: Using an SMP machine to make multiple indices on the same table - Mailing list pgsql-general

From Tom Lane
Subject Re: Using an SMP machine to make multiple indices on the same table
Date
Msg-id 648.1003806566@sss.pgh.pa.us
Whole thread Raw
In response to Using an SMP machine to make multiple indices on the same table  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
Responses Re: Using an SMP machine to make multiple indices on the  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
Re: Using an SMP machine to make multiple indices on the  (Martin Weinberg <weinberg@osprey.astro.umass.edu>)
List pgsql-general
Tree view 
Martin Weinberg <weinberg@osprey.astro.umass.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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Referential Integrity Violation not triggered
Next
From: Bruce Momjian
Date:
Subject: LIMIT TODO item