Re: automatic REINDEX-ing

you can use a cron job

--- On Tue, 8/12/08, Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com> wrote:

> From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
> Subject: [GENERAL] automatic REINDEX-ing
> To: "pgsql-general" <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general