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: 4.2.2.20020731092827.01e72808@ecint.ecinet.com (view raw or flat)
Thread:
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.
>
># REINDEX TABLE tlogs;
>
>Does anyone have any anecdotes about the time that a reindex should
>take?

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
>http://www.did-it.com
>eric(at)did-it(dot)com
>
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html

---------------------------------------------------------------------------- 
----------------------------------
Naomi Walker
Eldorado Computing, Inc
Chief Information Officer
nwalker(at)eldocomp(dot)com
602-604-3100 x242
                                    


In response to

Responses

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-2014 The PostgreSQL Global Development Group