Re: automatic REINDEX-ing - Mailing list pgsql-general

From Joao Ferreira gmail
Subject Re: automatic REINDEX-ing
Date
Msg-id 1218646718.13644.98.camel@jmf-ubuntu
Whole thread Raw
In response to Re: automatic REINDEX-ing  (Martijn van Oosterhout <kleptog@svana.org>)
List 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,



pgsql-general by date:

Previous
From: Jeff Ross
Date:
Subject: Column alias in where clause?
Next
From: Steve Crawford
Date:
Subject: Re: Postgres eats all memory