Thread: Reindex time?

Reindex time?

From
Ericson Smith
Date:
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?

- Ericson Smith
http://www.did-it.com
eric@did-it.com






Re: Reindex time?

From
Naomi Walker
Date:
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@did-it.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@eldocomp.com
602-604-3100 x242



Re: Reindex time?

From
Andrew Sullivan
Date:
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@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


Re: Reindex time?

From
Ericson Smith
Date:
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@did-it.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@did-it.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@eldocomp.com
> 602-604-3100 x242
>
>