Re: OpenMP in PostgreSQL-8.4.0 - Mailing list pgsql-performance

From Reydan Cankur
Subject Re: OpenMP in PostgreSQL-8.4.0
Date
Msg-id 07E8D473-F546-49D0-ADDD-BAA3FCB92303@gmail.com
Whole thread Raw
In response to Re: OpenMP in PostgreSQL-8.4.0  (Bruce Momjian <bruce@momjian.us>)
Responses Re: OpenMP in PostgreSQL-8.4.0  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: OpenMP in PostgreSQL-8.4.0  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
So I am trying to understand that can anyone rewrite some functions in
postgresql with OpenMP in order to increase performance.
does this work?

On Nov 29, 2009, at 3:05 PM, Bruce Momjian wrote:

> Reydan Cankur wrote:
>> You mean that backend does not support threading and everything I try
>> is useless
>> Is there a way to overcome this issue?
>> Is there anything I can adjust on backend to enable threading?
>> Is there any documentation to advise?
>
> Uh, "no" to all those questions.  We offer client-side threading, but
> not in the server.
>
> ---------------------------------------------------------------------------
>
>
>>
>> Best Regards,
>> Reydan
>>
>>
>> On Nov 28, 2009, at 6:42 PM, Tom Lane wrote:
>>
>>> Reydan Cankur <reydan.cankur@gmail.com> writes:
>>>> I am trying to run postgresql functions with threads by using
>>>> OpenMP.
>>>
>>> This is pretty much doomed to failure.  It's *certainly* doomed to
>>> failure if you just hack up one area of the source code without
>>> dealing
>>> with the backend's general lack of support for threading.
>>>
>>>             regards, tom lane
>>
>>
>> --
>> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
>> )
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-performance
>
> --
>  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +


pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: OpenMP in PostgreSQL-8.4.0
Next
From: Tom Lane
Date:
Subject: Re: OpenMP in PostgreSQL-8.4.0