you can use a cron job --- On Tue, 8/12/08, Joao Ferreira gmail <joao.miguel.c.ferreira@xxxxxxxxx> wrote: > From: Joao Ferreira gmail <joao.miguel.c.ferreira@xxxxxxxxx> > Subject: [GENERAL] automatic REINDEX-ing > To: "pgsql-general" <pgsql-general@xxxxxxxxxxxxxx> > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
