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

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
Databasecode and additional processes for the users—either one process for each connected user or one or more processes
sharedby multiple users. Most databases are multiuser because a primary advantages of a database is managing data
neededby multiple users simultaneously." 

[...]

"For each user connection, the application is run by a client process that is different from the dedicated server
processthat 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
doneusing threads (I think this is because Windows is not as efficient in running multiple processes as Linux/Unix).