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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
