you can use a cron job
--- On Tue, 8/12/08, Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com> wrote:
> From: Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>
> Subject: [GENERAL] automatic REINDEX-ing
> To: "pgsql-general" <pgsql-general@postgresql.org>
> Date: Tuesday, August 12, 2008, 3:13 PM
> Hello all
>
> [[[ while dealing with a disk size problem I realised my
> REINDEX cron
> script was not really being called every week :( so...
> ]]]
>
> I executed REINDEX by hand and the disk ocupation
> imediatelly dropped 6
> Giga...!!!
>
> is there a way to configure postgres to automatically
> execute the needed
> REINDEXING (on indexes and tables) for a given database....
>
> something similar to auto-vacuum... I guess....
>
> thx
> joao
>
>
>
> --
> Sent via pgsql-general mailing list
> (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
