Re: Contrib reindex script:

If you are going to implement this is there a way to do it so that it
doesn't lock the tables? We have had to reindex on a regular basis and
it locks up the tables when we do. The same problem with the old vacuum

David Blood

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Bruce Momjian
Sent: Thursday, June 13, 2002 11:13 AM
To: Shaun Thomas
Cc: PostgreSQL general list
Subject: Re: [GENERAL] Contrib reindex script:

Given the real file growth problems we have analyzed over the past
month, I think we need to rethink the tools we give to users.

First, I think we need a section in the admin/maintenance manual talking
about reindex. (We already have vacuum there, and I think reindex is
something that periodically also should be done.)

Second, reindex on an entire database only works for stand-alone
databases. Now, I know we can't reindex system tables on a live
database, but should we enable REINDEX all non-system tables for a
database, similar to how we use vacuum? Do we need the reindex script
like vacuumdb?

------------------------------------------------------------------------
---

Shaun Thomas wrote:
> I modeled this after the vacuumdb script that is distributed in the
> postgresql-base distribution. It can reindex a whole database,
specific
> tables, or just a single index. Being as we've had so much trouble
with
> things growing out of control, and the group seems to have tracked it
> down to indexes, here it is.
>
> I don't understand why we have a vacuumdb script, but not a reindex
> script, considering the fact that vacuum doesn't clean up indexes.
>
> Anyway, I didn't bother to comment it, I just copied vacuumdb and
> changed relevant parts. It's not pretty, but it works. Maybe later
> I'll produce one that doesn't look like it was coughed up by a robot.
>
> --
>
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
> | Shaun M. Thomas INN Database Administrator
|
> | Phone: (309) 743-0812 Fax : (309) 743-0830
|
> | Email: sthomas(at)townnews(dot)com AIM : trifthen
|
> | Web : www.townnews.com
|
> |
|
> | "Most of our lives are about proving something, either to
|
> | ourselves or to someone else."
|
> | -- Anonymous
|
>
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
>

Content-Description:

[ Attachment, skipping... ]

>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania
19026

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)