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

Re: Reindex time?

From: Ericson Smith <eric(at)did-it(dot)com>
To: Naomi Walker <nwalker(at)eldocomp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Reindex time?
Date: 2002-07-31 18:07:05
Message-ID: 1028138829.23774.8.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-admin
Here's what I found when the thing was finally completed:

Hardware:
Dual AMD 1600+, 4GB Ram, 110GB RAID, 2GB in shared memory for Pg

Environment:
We turned off most access to the database, load was down to about .2
when we started. We *did not* run a single process, as the manuals
recommended.

Reindex took ~45 Minutes on a single table with 10 indices, and
1.2Million Tuples. The reindex process ran on only a single CPU.

- Ericson Smith
Web Developer
http://www.did-it.com
eric(at)did-it(dot)com



On Wed, 2002-07-31 at 12:32, Naomi Walker wrote:
> 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

pgsql-admin by date

Next:From: Markus GieppnerDate: 2002-07-31 18:17:14
Subject: Re: 3-tier
Previous:From: Andrew SullivanDate: 2002-07-31 17:14:41
Subject: Re: Reindex time?

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