|
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@xxxxxxxxx > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general |
