Skip site navigation (1) Skip section navigation (2)

Re: Don't Thread On Me (PostgreSQL related)

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Don't Thread On Me (PostgreSQL related)
Date: 2012-01-26 23:18:38
Message-ID: jfsn0d$dps$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-general
Rodrigo E. De León Plicet wrote on 26.01.2012 22:52:
> Oracle claims it for releases going back to 7

Not true.

Quote from the Oracle concepts manual:

"Multiple-process Oracle (also called multiuser Oracle) uses several processes to run different parts of the Oracle Database code and additional processes for the users—either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantages of a database is managing data needed by multiple users simultaneously."

[...]

"For each user connection, the application is run by a client process that is different from the dedicated server process that runs the database code. Each client process is associated with its own server process"

Taken from: http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htm#i16977

So the Oracle architecture is very similar to the one that PostgreSQL uses - at least on Linux/Unix. On Windows this is done using threads (I think this is because Windows is not as efficient in running multiple processes as Linux/Unix).








In response to

Responses

pgsql-general by date

Next:From: Chris TraversDate: 2012-01-26 23:32:26
Subject: Re: Don't Thread On Me (PostgreSQL related)
Previous:From: Merlin MoncureDate: 2012-01-26 23:02:51
Subject: Re: Don't Thread On Me (PostgreSQL related)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group