On 04/24/2013 06:48 PM, S H wrote:
> What should be the interval for calling vacuum on template1 and postgres
> database in case
>
> 1. No table is created on template1.
>
> Should i pass analyze parameter for template1 and postgres vacuum.
I would suggest reading this section of the docs:
http://www.postgresql.org/docs/9.2/interactive/routine-vacuuming.html
If anything is still unclear afterwards feel free to ask follow up
questions.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com