PostgreSQL 8.x defaults
Craig Boston
craig at yekse.gank.org
Thu Apr 5 13:43:50 UTC 2007
I recently installed some PostgreSQL 8.2 servers (and upgraded some from
8.1), and it reminded me of a few lingering nits in our port that bug
me. Mostly the port seems that it can't make up its mind about VACCUM
strategy.
* We have a patch that sets autovacuum = yes in the default
postgresql.conf. However, it leaves the default stats_row_level = no,
so autovacuum doesn't actually run.
* Despite trying to turn on autovacuum, the port installs
periodic/daily/502.pgsql, which runs VACUUM (not even VACUUM ANALYZE)
by default nightly.
It seems to me that we should pick one or the other -- either
1. Fully enable autovacuum and default to daily_pgsql_vacuum_enable="NO"
to avoid a superfluous cron job
or
2. Leave the periodic job enabled and not tease people with an
ineffectual autovacuum = yes in postgresql.conf.
Of the two I'd prefer the former, but that's just my opinion.
Craig
More information about the freebsd-ports
mailing list