Re: src/bin/scripts seems a bit of a misnomer now
| От | Robert Treat |
|---|---|
| Тема | Re: src/bin/scripts seems a bit of a misnomer now |
| Дата | |
| Msg-id | 1056132562.7070.2341.camel@camel обсуждение исходный текст |
| Ответ на | Re: src/bin/scripts seems a bit of a misnomer now (Jon Jensen <jon@endpoint.com>) |
| Список | 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 по дате отправления: