Re: Regarding template1 database
| От | S H |
|---|---|
| Тема | Re: Regarding template1 database |
| Дата | |
| Msg-id | BAY155-W330F84084FF2ABE25B34F1FDB40@phx.gbl обсуждение исходный текст |
| Ответ на | Re: Regarding template1 database (Adrian Klaver <adrian.klaver@gmail.com>) |
| Ответы |
Re: Regarding template1 database
Re: Regarding template1 database Re: Regarding template1 database |
| Список | pgsql-general |
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
> 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
В списке pgsql-general по дате отправления: