On 04/24/2013 04:57 AM, S H wrote:
$ 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.
If you are getting 'No relations found' then there is nothing in template1. From psql try: \l+ This will show a list of databases in the cluster and their sizes.
- 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...
-- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
