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