Re: New index structure with Open MP - Mailing list pgsql-general

From Yves Weißig
Subject Re: New index structure with Open MP
Date
Msg-id 006f01cbc118$638cf870$2aa6e950$@rbg.informatik.tu-darmstadt.de
Whole thread Raw
In response to Re: New index structure with Open MP  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

thanks for the answer.
I understand that the backend is not thread safe, but it would be possible
to parallelize, let's say a big for-loop without breaking anything, or?

Greets, Yves W.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Sunday, January 30, 2011 10:38 PM
To: weissig@rbg.informatik.tu-darmstadt.de
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] New index structure with Open MP

=?ISO-8859-15?Q?Yves_Wei=DFig?= <weissig@rbg.informatik.tu-darmstadt.de>
writes:
> I am not aiming for full parallelization, only some parts of the
> algorithm regarding build, insert and search are going to be extended
> by Open MP. E.g. I want to parallelize searching in multiple pages by
> directing some portions to one thread and other portions to another
> thread. Do you think that this small amount of parallelization is
> possible? Or will there be complications with the used methods by the
> buffer manager and so on? What do you think? What are your thoughts?

The backend code is not designed for thread safety.  This is not a case
where "only a little bit" of parallelism is going to be safe.  It *will*
break.

            regards, tom lane


pgsql-general by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: One last Ruby question for tonight - Regarding UUID type
Next
From: Alban Hertroys
Date:
Subject: Re: Adding more space, and a vacuum question.