> > >
> > > How hard would it be to pre-fork an extra backend for the database a
> > > user just requested so if they next user asks for the same database, the
> > > backend would already be started?
> 
>   Perhaps I'm missing something, but it seems to me that the cost of forking
> a new backend would be pretty trivial compared to the expense of processing
> anything but the most simple query.  Am I wrong in that?

True on most OS's, but on Solaris, fork is pretty expensive, or at least
we are told.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

• Re: Pre-forking backend at 2001-10-01 02:16:27 from Steve Wolfe

pgsql-hackers by date

Next:	From: Lincoln Yeoh	Date: 2001-10-01 03:27:25
	Subject: Re: Pre-forking backend
Previous:	From: Joe Conway	Date: 2001-10-01 02:36:24
	Subject: cvs tip problems