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.klaver@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