Re: Question about Threads

Leon Oosterwijk wrote:
> All,
>
> I'm working on a school project that involves genetic algorithms. We thought
> it would be neat to parralelize the genetic algorithm in postgresql's query
> optimiser. We used pthreads and are able to spawn threads to deal with the
> query optimization, however on exit of the thread the postmaster blows up.
> Before we get into details is there any obvious reason postgres doesn't like
> to deal with threads?

Yes, the backend code is not thread-safe.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073