Hi!
On 29-Nov-99 Peter Eisentraut wrote:
> On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote:
>
>> When postgres will use posix threads or support pool of backends (like
>> apache)?
>> I guess it will increase speed very fast.
>
> Actually, the current model greatly benefits multiprocessor machines on
> certain free operating systems (which are our best customers). Those can
> only split _processes_ between CPUs but not _threads_. Thus mySQL will
> only use one processor no matter how many you have, whereas PostgreSQL can
> use one for each query (i.e. backend).
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.
>> Postgres is good database, but its too slow...
> There is no such thing as a free lunch ...
I hope my postgresql will be faster when I install more RAM :-(
SKiller
--------------------------
Sergei Keler
WebMaster of "ComSet"
E-Mail: [EMAIL PROTECTED]
http://www.comset.net
--------------------------
************
