[HACKERS] Why is autovacuum_freeze_max_age a postmaster setting?

2014-03-21 Thread Jim Nasby
Why do we require a restart to change autovacuum_freeze_max_age? Can’t we respawn the autovac workers to pick up the setting? (Or just pass the HUP down to them?) -- Jim C. Nasby, Data Architect j...@nasby.net 512.569.9461 (cell)

Re: [HACKERS] Why is autovacuum_freeze_max_age a postmaster setting?

2014-03-21 Thread Andres Freund
Hi, On 2014-03-21 16:49:53 -0500, Jim Nasby wrote: Why do we require a restart to change autovacuum_freeze_max_age? Can’t we respawn the autovac workers to pick up the setting? (Or just pass the HUP down to them?) It's more complex than notifying the workers. There's limits in shared memory

Re: [HACKERS] Why is autovacuum_freeze_max_age a postmaster setting?

2014-03-21 Thread Jim Nasby
On 3/21/14, 4:55 PM, Andres Freund wrote: Hi, On 2014-03-21 16:49:53 -0500, Jim Nasby wrote: Why do we require a restart to change autovacuum_freeze_max_age? Can’t we respawn the autovac workers to pick up the setting? (Or just pass the HUP down to them?) It's more complex than notifying the