Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 676722E0071
	for <pgsql-interfaces-postgresql.org@postgresql.org>;
	Wed, 28 Nov 2007 20:12:01 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 92980-06 for
	<pgsql-interfaces-postgresql.org@postgresql.org>;
	Wed, 28 Nov 2007 20:11:51 -0400 (AST)
Received: from web37302.mail.mud.yahoo.com (web37302.mail.mud.yahoo.com
	[209.191.90.245])
	by postgresql.org (Postfix) with SMTP id 17E112E004A
	for <pgsql-interfaces@postgresql.org>;
	Wed, 28 Nov 2007 20:11:57 -0400 (AST)
Received: (qmail 69573 invoked by uid 60001); 29 Nov 2007 00:11:56 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Message-ID;
	b=aOeeVgoXBknV40jMrKWHNm1gACplzlY6e/IJHb0L5bH86V9aIOtUxpkTF65wt/dVQVVtSF2KssXCKFACQAB8vKKwRh9lJ/sjf+QBj1I/o+Q6eryFoET0zjwspmJUK3rIHEaftqaeO5eWLXS2jA0D3n74LZw9CC00jMXmaQG8hlc=;
X-YMail-OSG: 
 Pt.u5zwVM1mAgTbe0iGndMyYDWkeBaQofBZyHF77JbfGIDkb_d3yptnUDBSK1wLxxR0V0S.qvrmDcDsEM78yaSYzqnmR9r6xAxmDvgYkh_eZjN1BOhY-
Received: from [66.226.193.82] by web37302.mail.mud.yahoo.com via HTTP;
	Wed, 28 Nov 2007 16:11:56 PST
X-Mailer: YahooMailRC/818.27 YahooMailWebService/0.7.157
Date: Wed, 28 Nov 2007 16:11:56 -0800 (PST)
From: andrew klassen <aptklassen@yahoo.com>
Subject: Re: postmaster process and multithreading
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces <pgsql-interfaces@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1827690015-1196295116=:69490"
Message-ID: <725224.69490.qm@web37302.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/20
X-Sequence-Number: 6664

--0-1827690015-1196295116=:69490
Content-Type: text/plain; charset=us-ascii

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


      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs
--0-1827690015-1196295116=:69490
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">I am only using a "C" based client with libpq. But, I did not explicitly turn</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">anything off like perl or tcl. Are these off by default? <BR>Is there some way to check in the gdb or compile log? </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">&nbsp;</DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">thanks.<BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Tom Lane &lt;tgl@sss.pgh.pa.us&gt;<BR>To: andrew klassen &lt;aptklassen@yahoo.com&gt;<BR>Cc: pgsql-interfaces &lt;pgsql-interfaces@postgresql.org&gt;<BR>Sent: Wednesday, November 28, 2007 5:08:12 PM<BR>Subject: Re: [INTERFACES] postmaster process and multithreading<BR><BR>andrew klassen &lt;<A href="mailto:aptklassen@yahoo.com" ymailto="mailto:aptklassen@yahoo.com">aptklassen@yahoo.com</A>&gt; writes:<BR>&gt; The reason I am asking is because sometimes the postmaster<BR>&gt; will create a core dump and it will show two threads but the<BR>&gt; backtrace on both threads does not show any helpful information.<BR><BR>Are you using plperl or pltcl?&nbsp; The backend shouldn't go multithreaded,<BR>but we've seen problems with those interpreters causing it to happen.<BR>(I suppose other language interpreters like python might be risks
 as<BR>well, but those two are the only ones trouble has been reported with.)<BR><BR>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; regards, tom lane<BR></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR></DIV></div><br>
      <hr size=1>Get easy, one-click access to your favorites. 
<a href="http://us.rd.yahoo.com/evt=51443/*http://www.yahoo.com/r/hs"> Make Yahoo! your homepage.</a>

</body></html>
--0-1827690015-1196295116=:69490--