Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum in the backend

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>,Andrew Dunstan <andrew(at)dunslane(dot)net>, swm(at)linuxworld(dot)com(dot)au,postgres(at)cybertec(dot)at, alvherre(at)surnet(dot)cl, pgman(at)candle(dot)pha(dot)pa(dot)us,pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum in the backend
Date: 2005-06-16 14:13:49
Message-ID: 42B1891D.1020609@pse-consulting.de (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Matthew T. O'Connor wrote:

> 
> Right, I think if VACUUM is improved than the semantics of AV in the 
> backend might change, but I think there will always be a need for some 
> maintenance, and a daemon that monitors the maintenance needs of your 
> database and fires off appropriate maintenance commands for you is 
> good.  No it doesn't solve all problems, but I think it solves a lot of 
> problems for a lot of people.  Besides VACUUM isn't the only the AV 
> does, it also does ANALYZE to keep your stats up-to-date and it watches 
> for XID wraparound.  It could also look for REINDEX opportunities and 
> who knows what else in the future.

Dave,

i wonder if we should aim to have pgAgent in the backend which was one 
of the reasons why I considered to have it converted from C++ to pure C.

There are many regular maintenance issues that AV can cover, some more 
it could cover and many more we can't even think of right now. Having an 
sql executing agent freely at hand (consistent on _every_ platform, 
without cron/anacron/at/younameit dependencies) should be helpful for that.

Regards,
Andreas

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-06-16 14:27:27
Subject: Re: Escape handling in strings
Previous:From: Steve AtkinsDate: 2005-06-16 14:05:01
Subject: Re: Autovacuum in the backend

pgsql-general by date

Next:From: Tom LaneDate: 2005-06-16 14:26:20
Subject: Re: DATATYPE for HEX
Previous:From: Steve AtkinsDate: 2005-06-16 14:05:01
Subject: Re: Autovacuum in the backend

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group