Postgres Pro
Downloads
Home   >   mailing lists

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

From Martin Weinberg
Subject Using an SMP machine to make multiple indices on the same table
Date
Msg-id 200110222138.RAA15338@osprey.astro.umass.edu
Whole thread Raw
Responses Re: Using an SMP machine to make multiple indices on the same table  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Using an SMP machine to make multiple indices on the same table  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Folks,

We have some big tables (1.2 billion records) and indexing is quite
time consuming.  Since we have this running on dual Athlon box, it
would be great to make indices in parallel.

On Postgresql 7.1.3, it seems that the table is locked after the
first "create index" is started up.  Is this right?  Is there any
way to do this in parallel?

--Martin

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to insert with a serial
Next
From: Keary Suska
Date:
Subject: Re: Upgrade