are there plans for a threaded alternative to multiple daemons?

Started by Clayton Vernonalmost 25 years ago3 messagesgeneral
Jump to latest
#1Clayton Vernon
cvernon@enron.com

I was wondering what the plans were for PostgreSQL to convert to the one process multithreaded approach, as Apache, Interbase and others are doing?

#2The Hermit Hacker
scrappy@hub.org
In reply to: Clayton Vernon (#1)
Re: are there plans for a threaded alternative to multiple daemons?

On Fri, 27 Apr 2001, Clayton Vernon wrote:

I was wondering what the plans were for PostgreSQL to convert to the
one process multithreaded approach, as Apache, Interbase and others
are doing?

there has been talk about doing some threads actions inside of a
process, but, if I recall my read of Apache2, they are still doing
multi-process, with threading inside of each process ...

#3Joseph Shraibman
jks@p1.selectacast.net
In reply to: The Hermit Hacker (#2)
Re: are there plans for a threaded alternative to multiple daemons?

That is exactly what we need for postgres. In particular JDBC could use
the ability to have a new connection to a backed that doesn't require a
new backed to use cursors for scrollable resultsets so big selects don't
have to download everything before results can be used. There are many
other reasons for having multiple connections to one backed process,
mainly to do with different transactions not screwing each other up.

On Sat, 28 Apr 2001, The Hermit Hacker wrote:

Show quoted text

On Fri, 27 Apr 2001, Clayton Vernon wrote:

I was wondering what the plans were for PostgreSQL to convert to the
one process multithreaded approach, as Apache, Interbase and others
are doing?

there has been talk about doing some threads actions inside of a
process, but, if I recall my read of Apache2, they are still doing
multi-process, with threading inside of each process ...