pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAutoVaccuum process start as its off in potgresql.conf]
2+ messages / 2 participants
[nested] [flat]
* AutoVaccuum process start as its off in potgresql.conf]
@ 2008-11-27 03:43 AmitKumar Jain <amitjain@synechron.com>
0 siblings, 1 reply; 2+ messages in thread
From: AmitKumar Jain @ 2008-11-27 03:43 UTC (permalink / raw)
To: pgsql-admin
Hi ,
I am using PostgreSQL 8.3 version . The autovacuum process is stucking
my system as it automtically start even though its off is
postgresql.conf.
2. Is there any benchmark tool for Autovacuum process or can we know how much time this proces will take to complete?
Thanks in Advance.
Regards
Amit
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: AutoVaccuum process start as its off in potgresql.conf]
@ 2008-11-27 15:49 Tino Schwarze <postgresql@tisc.de>
parent: AmitKumar Jain <amitjain@synechron.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tino Schwarze @ 2008-11-27 15:49 UTC (permalink / raw)
To: pgsql-admin
On Thu, Nov 27, 2008 at 09:13:04AM +0530, AmitKumar Jain wrote:
> I am using PostgreSQL 8.3 version . The autovacuum process is stucking
> my system as it automtically start even though its off is
> postgresql.conf.
>
> 2. Is there any benchmark tool for Autovacuum process or can we know how
> much time this proces will take to complete?
If the autovacuum process kicks in even if it is disabled, you database
is in danger of XID wraparound! You should check your vacuum policy
(e.g. if it covers all of your databases and tables, including the
system databases).
Tino.
--
"What we nourish flourishes." - "Was wir nähren erblüht."
www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-11-27 15:49 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-11-27 03:43 AutoVaccuum process start as its off in potgresql.conf] AmitKumar Jain <amitjain@synechron.com>
2008-11-27 15:49 ` Tino Schwarze <postgresql@tisc.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox