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 the

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

[PATCHES] autovacuum: multiple workers

2007-03-27 Thread Alvaro Herrera
Hi, This is the patch to put multiple workers into autovacuum. This patch applies after the recheck patch I just posted. 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

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,