> > >
> > > 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
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|