| From: | Zenaan Harkness <zen(at)freedbms(dot)net> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Regarding template1 database |
| Date: | 2013-04-24 01:31:08 |
| Message-ID: | CAOsGNSSVWwZQ8K17H_mad==a7bCNKX+v+JmjkXgbF1SWwWRyhQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 4/24/13, S H <msq001(at)live(dot)com> wrote:
> 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.
Sounds like you have used "template1" as your live database.
OK, so from your point of view, template1 IS your database.
In that case, perhaps google for "postgresql transaction monitoring"
or similar. Others might be able to give you better advice/links.
Good luck,
Zenaan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-04-24 02:40:03 | Re: Regarding template1 database |
| Previous Message | Kevin Grittner | 2013-04-23 21:49:11 | Re: Log messages regarding automatic vacuum and exclusive locks |