Skip site navigation (1) Skip section navigation (2)

Re: Reindex time?

From: Naomi Walker <nwalker(at)eldocomp(dot)com>
To: Ericson Smith <eric(at)did-it(dot)com>,pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Reindex time?
Date: 2002-07-31 16:32:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
At 05:58 AM 7/31/2002 , Ericson Smith wrote:
>A  quick question.
>We're reindexing a table with 1.2 million tuples and around 10 indexes.
>Does anyone have any anecdotes about the time that a reindex should

I would imagine it depends on how much you have in the way of system 
resources (memory, cpu (how fast, how many)) at the time it is done.

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?

>- Ericson Smith
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?

Naomi Walker
Eldorado Computing, Inc
Chief Information Officer
602-604-3100 x242

In response to


pgsql-admin by date

Next:From: Andrew SullivanDate: 2002-07-31 17:14:41
Subject: Re: Reindex time?
Previous:From: Elielson FontaneziDate: 2002-07-31 16:14:45
Subject: --enable-locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group