> On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote:
>
> > Yes! But I recommend backend pool too. What is it? The postmaster task
> > runs now backend for each query. Good. But After query backend
> > finished. I recommend to stay backend running within a some timeout.
> > If the next query occured the postmaster redirect query to any idle
> > backend or run a new one unless. Then backend serve some connections
> > it shut down itself, this prevents memory leaks.
> >
> > Using this method we can get same speed like as with threads.
>
> Actually, with how fast Bruce has been able to get the start time on a
> backend process, I seriously doubt that you'll get much more of a speed
> up, but if you wish to work on creating a 'backend pool' of processes, I
> don't think anyone will complain...
7.0 will be even faster on startup because of index use on cache loads.
I couldn't measure a speedup because most other startup routines too
more time, but I am sure some people will see speedup.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
************
