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? 

Thank you. 

Leon


Sat, 8 Nov 2003 15:47:30 -0600
"Leon Oosterwijk" <leon@isdn.net>
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Sat, 8 Nov 2003 20:58:09 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Question about Threads