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

From: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Using an SMP machine to make multiple indices on the same table
Date: 2001-10-22 21:38:23
Message-ID: 200110222138.RAA15338@osprey.astro.umass.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Cao 2001-10-22 21:39:24 Solaris 2.6 support.
Previous Message Mihai Gheorghiu 2001-10-22 21:23:49 Re: Problems setting up PostgreSQL and Tomcat JDBC connection

Browse pgsql-hackers by date

  From Date Subject
Next Message speedboy 2001-10-22 22:52:05 Re: createlang difficulty.
Previous Message Tom Lane 2001-10-22 21:37:24 Re: CREATE TABLE AS / WITHOUT OIDs?