Re: Contrib reindex script: - Mailing list pgsql-general

From Jason Earl
Subject Re: Contrib reindex script:
Date
Msg-id 87u1pj23vr.fsf@npa01zz001.simplot.com
Whole thread Raw
In response to Contrib reindex script:  (Shaun Thomas <sthomas@townnews.com>)
Responses Re: Contrib reindex script:
List pgsql-general
Shaun Thomas <sthomas@townnews.com> writes:

> 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.

Hey thanks, I was just wondering if such a thing were available.

How has your migration to 7.2?  Are you still have problems with the
database growing out of control?

Jason

pgsql-general by date:

Previous
From: Andrey Mosienko
Date:
Subject: Reference to NEW, OLD values in TRIGGER
Next
From: "Booth, Robert"
Date:
Subject: NOT IN query issues