Re: Experimental patch for inter-page delay in VACUUM

Joe Conway <mail@joeconway.com>

From: Joe Conway <mail@joeconway.com>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Jan Wieck <JanWieck@yahoo.com>, Ang Chin Han <angch@bytecraft.com.my>, Christopher Browne <cbbrowne@acm.org>, pgsql-hackers@postgresql.org
Date: 2003-11-10T04:54:25Z
Lists: pgsql-hackers
Bruce Momjian wrote:
> Having another process do the writing does allow some paralellism, but
> people don't seem to care of buffers having to be read in from the
> kernel buffer cache, so what big benefit do we get by having someone
> else write into the kernel buffer cache, except allowing a central place
> to fsync, and is it worth it considering that it might be impossible to
> configure a system where the writer process can keep up with all the
> backends?

This might be far fetched, but I wonder if having a writer process opens 
up the possibility of running PostgreSQL in a cluster? I'm thinking of 
two servers, mounted to the same data volume, and some kind of 
coordination between the writer processes. Anyone know if this is 
similar to how Oracle handles RAC?

Joe