you can use a cron job
--- On Tue, 8/12/08, Joao Ferreira gmail <[EMAIL PROTECTED]> wrote: > From: Joao Ferreira gmail <[EMAIL PROTECTED]> > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
