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? Jon ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
