Re: OpenMP in PostgreSQL-8.4.0

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