Re: [HACKERS] Why is vacuum_defer_cleanup_age PGC_USERSET?

2010-07-07 Thread Josh Berkus
On 7/3/10 10:07 AM, Tom Lane wrote: > It seems to me it ought to be PGC_SIGHUP. +1 I believe it's userset because the other vacuum parameters are, and that nobody thought about it much. -- -- Josh Berkus PostgreSQL Experts

Re: [HACKERS] Why is vacuum_defer_cleanup_age PGC_USERSET?

2010-07-03 Thread Simon Riggs
On Sat, 2010-07-03 at 13:07 -0400, Tom Lane wrote: > It seems to me it ought to be PGC_SIGHUP. In the first place, the > actually important value under normal circumstances is going to be > that seen by autovac workers. There is also some impact on HOT > cleanup, but I can't see any sane argument

[HACKERS] Why is vacuum_defer_cleanup_age PGC_USERSET?

2010-07-03 Thread Tom Lane
It seems to me it ought to be PGC_SIGHUP. In the first place, the actually important value under normal circumstances is going to be that seen by autovac workers. There is also some impact on HOT cleanup, but I can't see any sane argument why you don't want all backends to be applying the same va