Add pg_autovacuum to postgresql port

[decibel (Jim Nasby)]

Running a postgresql database without vacuuming it is a sure-fire way to completely hose performance; I can't think of any downside to setting pg_autovacuum up to run when postgresql does.

I'll attach a dirt-simple script I use to start pg_autovacuum. Note that autovacuum must start after postgresql; I believe renaming pgsql.sh to 010.pgsql.sh should ensure this.

[decibel (Jim Nasby)]

Script to start pg_autovacuum

[decibel (Jim Nasby)]

Script to start pg_autovacuum

[mww@…]

assign to maintainer

[mww@…]

this will need some extra work on the Portfile as 'contrib' doesnt get compiled by default. Adding pg_autovacuum with an extra startup script seems to be of no advantage compared to adding pg_autovacuum to the postgres-startup script itself;

[decibel (Jim Nasby)]

I agree completely that it makes more sense to put autovacuum in the main startup script. I only did it this way because it was something I already had around from a FreeBSD box.

FWIW, simply doing a cd blah/contrib/pg_autovacuum && gnumake install worked great for me.

By the way, there's also a bug in autovacuum in 7.4.2 that might be worth fixing; ​http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg45209.html is the end of a thread about it.

[mww@…]

pg_autovacuum is now part of the installed binaries of the postgresql port;

[mww@…]

pgsql.sh now starts pg_autovacuum by default (and supplies the options to the postmaster needed to run autovacuum)