Re: Regarding template1 database

I am working on some legacy product. In which template1 vacuuming with Analyze is executed through cron job every one hour and some times it is taking lot of time.I want to know if there is any major update/insert in template1 at some time, so i wanted to monitor the number of insertions and deletions done in template1.

> As mentioned earlier the template databases are not really supposed to
> be used as active databases, but as templates for creating new
> databases. Also, as John mentioned system tables/views are often global
> and do not apply to a particular database. It would be helpful to
> explain what it is you want to accomplish. For example, this is for
> security purposes and I want to know if someone is using template1.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)gmail(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general