Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 223392E34A6 for ; Wed, 28 Nov 2007 19:08:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 21984-03 for ; Wed, 28 Nov 2007 19:08:09 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 573F12E34A4 for ; Wed, 28 Nov 2007 19:08:13 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lASN8CHH025477; Wed, 28 Nov 2007 18:08:12 -0500 (EST) To: andrew klassen cc: pgsql-interfaces Subject: Re: postmaster process and multithreading In-reply-to: <642562.84474.qm@web37312.mail.mud.yahoo.com> References: <642562.84474.qm@web37312.mail.mud.yahoo.com> Comments: In-reply-to andrew klassen message dated "Wed, 28 Nov 2007 14:40:06 -0800" Date: Wed, 28 Nov 2007 18:08:12 -0500 Message-ID: <25476.1196291292@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/19 X-Sequence-Number: 6663 andrew klassen 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