On 04/24/2013 06:48 PM, S H wrote:
What should be the interval for calling vacuum on template1 and postgres
database in case
1. No table is created on template1.
Should i pass analyze parameter for template1 and postgres vacuum.
I would suggest reading this section of the docs:
http://www.po
What should be the interval for calling vacuum on template1 and postgres
database in case
1. No table is created on template1.
Should i pass analyze parameter for template1 and postgres vacuum.
On 04/24/2013 04:57 AM, S H wrote:
$ sudo -u postgres psql template1
psql (9.2.4)
Type "help" for help.
template1=# \d
No relations found.
I am getting as mentioned above. I am not sure what is taking vacuuming
long time.
If you are getting 'No relations found' then t
$ sudo -u postgres psql template1
psql (9.2.4)
Type "help" for help.
template1=# \d
No relations found.
I am getting as mentioned above. I am not sure what is taking vacuuming long
time.
- What is the recommendation of vacuuming for wraparound issue for template1 -
Once
On 4/23/2013 7:26 AM, S H wrote:
... template1 vacuuming with Analyze is executed through cron job
every one hour and some times it is taking lot of time
what do you get from...
$ sudo -u postgres psql template1
psql (9.2.4)
Type "help" for help.
template1=# \d
No relation
On 04/23/2013 07:26 AM, S H 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 monit
On 4/24/13, S H 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
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 del
On 04/22/2013 08:08 PM, S H wrote:
> - I want to know the tables of tempate1
There are none, unless you choose to add some.
I got it there are no tables. What about the system tables of template1
database ? Are they updated or not?
> > - If i want to monitor the transactions done in the temp
On 4/22/2013 8:08 PM, S H wrote:
I want to monitor externally, without changing the database. If there
are some system queries which can tell me what are the number of
database insertion/updation in the template1 ( including system table
it will be helpful for me).
the system tables include t
> > - I want to know the tables of tempate1> > There are none, unless you
> > choose to add some.I got it there are no tables. What about the system
> > tables of template1 database ? Are they updated or not?
> > - If i want to monitor the transactions done in the template1 database (
> > inserti
On 04/22/2013 07:48 PM, S H wrote:
I would like some assistance in understanding of template1 database.
- I want to know the tables of tempate1
There are none, unless you choose to add some.
- I want to know when there is any insertion/updation in template1
theoretically.
You could if you c
I would like some assistance in understanding of template1 database.- I want to
know the tables of tempate1- I want to know when there is any
insertion/updation in template1 theoretically.- If i want to monitor the
transactions done in the template1 database ( insertion/updation ) , is there
an
13 matches
Mail list logo
