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@xxxxxxxxxxxxx] Sent: Sunday, January 30, 2011 10:38 PM To: weissig@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: New index structure with Open MP =?ISO-8859-15?Q?Yves_Wei=DFig?= <weissig@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general