Re: Question about Threads - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Question about Threads
Date
Msg-id 200311090158.hA91w9028177@candle.pha.pa.us
Whole thread Raw
In response to Question about Threads  ("Leon Oosterwijk" <leon@isdn.net>)
List pgsql-hackers
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,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Question for the developers.
Next
From: Joe Conway
Date:
Subject: Re: [BUGS] postgresql-7.4RC1 - unrecognized privilege type