Re: src/bin/scripts seems a bit of a misnomer now - Mailing list pgsql-hackers

From Robert Treat
Subject Re: src/bin/scripts seems a bit of a misnomer now
Date
Msg-id 1056132562.7070.2341.camel@camel
Whole thread Raw
In response to Re: src/bin/scripts seems a bit of a misnomer now  (Jon Jensen <jon@endpoint.com>)
List pgsql-hackers
On Thu, 2003-06-19 at 12:09, Jon Jensen wrote:
> On Thu, 19 Jun 2003, Christopher Kings-Lynne wrote:
> 
> > Does anyone care about contrib/reindexdb anymore?
> 
> I would've found it handy, but didn't know about it and wrote my own in
> Perl. Inside a transaction it drops the index then rebuilds it using what
> it gets from pg_get_indexdef(), and it looks at the index files on disk
> before and after to show disk space saved (or grown) per index and total.  
> I run it weekly in cron.
> 
> Is something like that of use to anyone else?
> 

I think something like this was either posted to the list, put on gborg,
or maybe hidden in contrib somewhere. I'd like a copy if you don't mind,
I currently use reindex regularly on my database but your script sounds
a little more informational.

Robert Treat 
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Commands to change name, schema, owner
Next
From: "Dann Corbit"
Date:
Subject: Re: Two weeks to feature freeze