Skip site navigation (1) Skip section navigation (2)

Re: OpenMP in PostgreSQL-8.4.0

From: Reydan Cankur <reydan(dot)cankur(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: OpenMP in PostgreSQL-8.4.0
Date: 2009-11-29 13:24:30
Message-ID: 07E8D473-F546-49D0-ADDD-BAA3FCB92303@gmail.com (view raw or flat)
Thread:
Lists: 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(dot)cankur(at)gmail(dot)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(at)postgresql(dot)org 
>> )
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-performance
>
> -- 
>  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
>  EnterpriseDB                             http://enterprisedb.com
>
>  + If your life is a hard drive, Christ can be your backup. +


In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2009-11-29 14:52:15
Subject: Re: OpenMP in PostgreSQL-8.4.0
Previous:From: Bruce MomjianDate: 2009-11-29 13:05:31
Subject: Re: OpenMP in PostgreSQL-8.4.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group