Re: Reindex time?

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Reindex time?
Date: 2002-07-31 17:14:41
Message-ID: 20020731131441.B7595@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Jul 31, 2002 at 09:32:55AM -0700, Naomi Walker wrote:
>
> But to the list, supposing the entire machine was idle, would a reindex
> spread itself amount cpu's, and perform the task in pieces, or is it bound
> to a cpu?

A single REINDEX command works with one backend, which is a single
process. Therefore, it'll only work on one CPU.

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ericson Smith 2002-07-31 18:07:05 Re: Reindex time?
Previous Message Naomi Walker 2002-07-31 16:32:55 Re: Reindex time?