Re: Pre-forking backend - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Pre-forking backend
Date
Msg-id 200110010250.f912oIT13728@candle.pha.pa.us
Whole thread Raw
In response to Re: Pre-forking backend  ("Steve Wolfe" <steve@iboats.com>)
List pgsql-hackers
> > >
> > > 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@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Joe Conway"
Date:
Subject: cvs tip problems
Next
From: Lincoln Yeoh
Date:
Subject: Re: Pre-forking backend