Re: [PATCHES] autovacuum: multiple workers

2007-03-28 Thread Simon Riggs
On Wed, 2007-03-28 at 09:39 -0400, Alvaro Herrera wrote: > What other auxiliary processes are you envisioning, anyway? WAL Writer, multiple bgwriters, checkpoint process, parallel query and sort slavesplus all the ones I haven't dreamed of yet. No need to agree with my short list, but we do s

Re: [PATCHES] autovacuum: multiple workers

2007-03-28 Thread Alvaro Herrera
Simon Riggs wrote: > On Tue, 2007-03-27 at 17:41 -0400, Alvaro Herrera wrote: > > > The main change is to have an array of Worker structs in shared memory; > > each worker checks the current table of all other Workers, and skips a > > table that's being vacuumed by any of them. It also rechecks t

Re: [PATCHES] autovacuum: multiple workers

2007-03-27 Thread Simon Riggs
On Tue, 2007-03-27 at 17:41 -0400, Alvaro Herrera wrote: > The main change is to have an array of Worker structs in shared memory; > each worker checks the current table of all other Workers, and skips a > table that's being vacuumed by any of them. It also rechecks the table > before vacuuming,