Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-12-05 Thread Denis Lussier
Sounds more like a school project than a proper performance question. On 11/28/09, Reydan Cankur wrote: > Hi, > > I am trying to run postgresql functions with threads by using OpenMP. > I tried to parallelize slot_deform_tuple function(src/backend/access/ > common/heaptuple.c) and added below lin

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-29 Thread Greg Stark
On Sun, Nov 29, 2009 at 1:24 PM, Reydan Cankur wrote: > So I am trying to understand that can anyone rewrite some functions in > postgresql with OpenMP in order to increase performance. > does this work? Well you have to check the code path you're parallelizing for any function calls which might

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-29 Thread Tom Lane
Reydan Cankur writes: > So I am trying to understand that can anyone rewrite some functions in > postgresql with OpenMP in order to increase performance. > does this work? Not without doing a truly vast amount of infrastructure work first. Infrastructure work that, by and large, would add cycle

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-29 Thread Reydan Cankur
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 usel

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-29 Thread Bruce Momjian
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 c

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-28 Thread Reydan Cankur
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? Best Regards, Reydan On Nov 28, 2009, at 6:42 PM, Tom Lane wrote: Reyd

Re: [PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-28 Thread Tom Lane
Reydan Cankur 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.

[PERFORM] OpenMP in PostgreSQL-8.4.0

2009-11-28 Thread Reydan Cankur
Hi, I am trying to run postgresql functions with threads by using OpenMP. I tried to parallelize slot_deform_tuple function(src/backend/access/ common/heaptuple.c) and added below lines to the code. #pragma omp parallel { #pragma omp sections { #pragma omp sec