On 4/23/2013 7:26 AM, S H wrote:
... template1 vacuuming with Analyze is executed through cron job every one hour and some times it is taking lot of time
what do you get from...
$ sudo -u postgres psql template1
psql (9.2.4)
Type "help" for help.
template1=# \d
No relations found. thats normal above. do you have tables and stuff in this template1 database?
and to see about the rest...
template1=# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
----------------+-------------+-----------+-------------+-------------+------------------------
blogs | blogs | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
junk | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
pierce | pierce | UTF8 | en_US.UTF-8 | en_US.UTF-8 | pierce=CTc/pierce +
| | | | | =Tc/pierce
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres=C*T*/postgres+
| | | | | =c/postgres
(5 rows)
template1=#
--
john r pierce 37N 122W
somewhere on the middle of the left coast