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

On Thu, Jan 26, 2012 at 3:18 PM, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> 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."
>

Oracle offers intra-query parallelism. I am not entirely sure how they do
it, but it is supported. I don't know if these subtasks are pthreads
within the separate session process or if they are additional processes.

Best Wishes,
Chris Travers