Re: automatic REINDEX-ing

From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: automatic REINDEX-ing
Date: 2008-08-13 16:58:38
Message-ID: 1218646718.13644.98.camel@jmf-ubuntu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Because VACUUM FULL needs to move stuff around in the table which means it
> need to mess around with the indexes (adding new entries). Ordinary
> VACUUM only needs to delete stuff so doesn't cause anywhere near as
> many problems.

so.... in the event that I really end up running VACUUM FULL once in a
while, it seems to me it is a good idea to run REINDEX.

Is this correct ?

thx
joao

>
> Have a nice day,

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2008-08-13 17:03:06 Re: Postgres eats all memory
Previous Message Martijn van Oosterhout 2008-08-13 16:53:37 Re: automatic REINDEX-ing