$ sudo -u postgres psql template1
psql (9.2.4)
Type "help" for help.
template1=# \d
No relations found.
I am getting as mentioned above. I am not sure what is taking vacuuming long time.
- What is the recommendation of vacuuming for wraparound issue for template1 - Once in month/week/year?
- Is it required to run analyze on template1 and postgres database (system databases).
Since it is already in production i can maximum change the interval and vacuum options and nothing more...