Re: Pre-forking backend

Darren Johnson <darren.johnson@home.com>

From: Darren Johnson <darren.johnson@home.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bradley McLean <brad@bradm.net>, Gavin Sherry <swm@linuxworld.com.au>, pgsql-hackers@postgresql.org
Date: 2001-09-30T23:51:06Z
Lists: pgsql-hackers
> 
> Once we have schemas (7.3, I hope), I think a lot of installations will
> have only one production database.  However, if we were going to do this
> what we'd probably do is allow the DBA to configure the postmaster to
> start N pre-forked backends per database, where N can depend on the
> database.  There's no reason to limit it to just one database.

The optimized version of Postgres-R uses pre-forked backends for 
handling remote
write sets.  It currently uses one user/database, so I'm all for having 
a configurable
parameter for starting a pool of backends for each database.  We'll have 
to make sure
that number * the number of databases is lower than the max number of 
backends at
start up.

Darren

> 
>