pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
autovacuum
3+ messages / 2 participants
[nested] [flat]

* autovacuum
@ 2003-07-29 11:56  Christopher Browne <cbbrowne@libertyrms.info>
  0 siblings, 0 replies; 3+ messages in thread

From: Christopher Browne @ 2003-07-29 11:56 UTC (permalink / raw)
  To: pgsql-performance

Shridhar wrote:
>There is an auto-vacuum daemon in contrib and if I understand it correctly,
>it is not getting much of a field testing. How about you guys installing it
>and trying it.

I'm one of those that has been running it; there are numerous test systems
around where it has been running off and on over the last few months.

The thing I keep reconstructing is the script to automatically start it
up.  It should get started shortly after the postmaster starts up; based
on variations on the systems I work with, there's a lot of variation on
how that gets handled, which hasn't let me see anything stabilize as the
Right Way to start it up :-(.
-- 
(reverse (concatenate 'string "ofni.smrytrebil@" "enworbbc"))
<http://dev6.int.libertyrms.info/;
Christopher Browne
(416) 646 3304 x124 (land)





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Autovacuum
@ 2003-07-29 12:03  Christopher Browne <cbbrowne@libertyrms.info>
  0 siblings, 1 reply; 3+ messages in thread

From: Christopher Browne @ 2003-07-29 12:03 UTC (permalink / raw)
  To: pgsql-performance

"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> wrote:
>It is called as pgavd..

No, it is called pg_autovacuum

"pgavd" was a previous attempt at this that was being distributed on
gborg.  Its parser ussage (I don't recall if it was just lex or whether it
also included yacc) made it troublesome to get to run on all platforms.

The code for pg_autovacuum is in 7.4, in contrib; it also works perfectly
well in 7.3, so you should be able to grab the directory and drop the code
into the 7.3 contrib area.
-- 
(reverse (concatenate 'string "ofni.smrytrebil@" "enworbbc"))
<http://dev6.int.libertyrms.info/;
Christopher Browne
(416) 646 3304 x124 (land)





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Autovacuum
@ 2003-07-29 12:31  Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
  parent: Christopher Browne <cbbrowne@libertyrms.info>
  0 siblings, 0 replies; 3+ messages in thread

From: Shridhar Daithankar @ 2003-07-29 12:31 UTC (permalink / raw)
  To: pgsql-performance

On 29 Jul 2003 at 8:03, Christopher Browne wrote:

> "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> wrote:
> >It is called as pgavd..
> 
> No, it is called pg_autovacuum
> 
> "pgavd" was a previous attempt at this that was being distributed on
> gborg.  Its parser ussage (I don't recall if it was just lex or whether it
> also included yacc) made it troublesome to get to run on all platforms.

Yeah.. I wrote that and didn't quite maintain that after. Mathew finished 
pg_autovacuum shortly after that.

I recall reading some bug reports and I fixed couple of problems in CVS but 
didn't bother to make a release after there was a contrib module..

 
> The code for pg_autovacuum is in 7.4, in contrib; it also works perfectly
> well in 7.3, so you should be able to grab the directory and drop the code
> into the 7.3 contrib area.

Good to know that..


Bye
 Shridhar

--
Flon's Law:	There is not now, and never will be, a language in	which it is the least bit difficult to write bad programs.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2003-07-29 12:31 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-29 11:56 autovacuum Christopher Browne <cbbrowne@libertyrms.info>
2003-07-29 12:03 Autovacuum Christopher Browne <cbbrowne@libertyrms.info>
2003-07-29 12:31 ` Re: Autovacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

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