Re: postmaster process and multithreading

I am only using a "C" based client with libpq. But, I did not explicitly turn

anything off like perl or tcl. Are these off by default?
Is there some way to check in the gdb or compile log?

 

thanks.

----- Original Message ----
From: Tom Lane <tgl@sss.pgh.pa.us>
To: andrew klassen <aptklassen@yahoo.com>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Sent: Wednesday, November 28, 2007 5:08:12 PM
Subject: Re: [INTERFACES] postmaster process and multithreading

andrew klassen <aptklassen@yahoo.com> writes:
> The reason I am asking is because sometimes the postmaster
> will create a core dump and it will show two threads but the
> backtrace on both threads does not show any helpful information.

Are you using plperl or pltcl?  The backend shouldn't go multithreaded,
but we've seen problems with those interpreters causing it to happen.
(I suppose other language interpreters like python might be risks as
well, but those two are the only ones trouble has been reported with.)

            regards, tom lane