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

From Tom Lane
Subject Re: OpenMP in PostgreSQL-8.4.0
Date
Msg-id 14393.1259506335@sss.pgh.pa.us
Whole thread Raw
In response to Re: OpenMP in PostgreSQL-8.4.0  (Reydan Cankur <reydan.cankur@gmail.com>)
List pgsql-performance
Reydan Cankur <reydan.cankur@gmail.com> 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 cycles and lose
performance.  So by the time you got to the point of being able to
do micro-optimizations like parallelizing individual functions, you'd
have dug a pretty large performance hole that you'd have to climb out
of before showing any net benefit for all this work.

If you search the PG archives for discussions of threading you should
find lots and lots of prior material.

            regards, tom lane

pgsql-performance by date:

Previous
From: Reydan Cankur
Date:
Subject: Re: OpenMP in PostgreSQL-8.4.0
Next
From: Greg Stark
Date:
Subject: Re: OpenMP in PostgreSQL-8.4.0