Re: OpenMP in PostgreSQL-8.4.0

[Reydan Cankur <reydan(dot)cankur(at)gmail(dot)com>]

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