Re: New index structure with Open MP

From: Yves Weißig <weissig(at)rbg(dot)informatik(dot)tu-darmstadt(dot)de>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: New index structure with Open MP
Date: 2011-01-31 07:27:55
Message-ID: 006f01cbc118$638cf870$2aa6e950$@rbg.informatik.tu-darmstadt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Sunday, January 30, 2011 10:38 PM
To: weissig(at)rbg(dot)informatik(dot)tu-darmstadt(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] New index structure with Open MP

=?ISO-8859-15?Q?Yves_Wei=DFig?= <weissig(at)rbg(dot)informatik(dot)tu-darmstadt(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2011-01-31 07:53:06 Re: Adding more space, and a vacuum question.
Previous Message Jonathan S. Katz 2011-01-31 03:02:40 Re: One last Ruby question for tonight - Regarding UUID type