Thread: Can Autovaccuum also reindex

Greetings,

Hopefully this can be easily answered but I have not seen any reference to this within the online docs and mailing list archives.  Can or does autovaccuum also have the capability to reindex; or, is this something that needs to be placed within a custom cron job? 

Many thanks!

Eric Crowe

This message (including any attachments) may contain confidential information intended for a specific individual and purpose. If you are not the intended recipient, delete this message. If you are not the intended recipient, disclosing, copying, distributing, or taking any action based on this message is strictly prohibited.

On Apr 21, 2009, at 4:43 PM, Crowe, Eric wrote:

> Greetings,
>
> Hopefully this can be easily answered but I have not seen any
> reference to this within the online docs and mailing list archives.
> Can or does autovaccuum also have the capability to reindex; or, is
> this something that needs to be placed within a custom cron job?
>
> Many thanks!
>
> Eric Crowe
>

autovacuum will kick off VACUUMs and ANALYZEs but no REINDEXes.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k

Crowe, Eric wrote:
> Greetings,
>
> Hopefully this can be easily answered but I have not seen any reference
> to this within the online docs and mailing list archives.  Can or does
> autovaccuum also have the capability to reindex; or, is this something
> that needs to be placed within a custom cron job?

Autovacuum never attempts anything that might require exclusive locks.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support