From owner-freebsd-questions@FreeBSD.ORG Wed Dec 15 07:11:40 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 023A4106564A for ; Wed, 15 Dec 2010 07:11:40 +0000 (UTC) (envelope-from cswiger@mac.com) Received: from asmtpout026.mac.com (asmtpout026.mac.com [17.148.16.101]) by mx1.freebsd.org (Postfix) with ESMTP id DD2F88FC0A for ; Wed, 15 Dec 2010 07:11:39 +0000 (UTC) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; charset=us-ascii Received: from [17.151.87.195] by asmtp026.mac.com (Sun Java(tm) System Messaging Server 6.3-7.04 (built Sep 26 2008; 64bit)) with ESMTPSA id <0LDG005GZJYQ9X30@asmtp026.mac.com> for freebsd-questions@freebsd.org; Tue, 14 Dec 2010 23:11:33 -0800 (PST) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 suspectscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx engine=6.0.2-1010190000 definitions=main-1012140257 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.2.15,1.0.148,0.0.0000 definitions=2010-12-15_03:2010-12-14, 2010-12-14, 1970-01-01 signatures=0 From: Chuck Swiger In-reply-to: Date: Tue, 14 Dec 2010 23:11:10 -0800 Message-id: <77F6EE21-0872-4B6F-A534-07911A520FAB@mac.com> References: To: Dave Pooser X-Mailer: Apple Mail (2.1082) Cc: freebsd-questions@freebsd.org Subject: Re: PostgreSQL + 8.1 RELEASE + DTrace = pain? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 15 Dec 2010 07:11:40 -0000 On Dec 14, 2010, at 9:01 PM, Dave Pooser wrote: > Is there a better place I could/should be asking questions about PostgreSQL > and DTrace on FreeBSD? Or is this combination still black magic at this > point? freebsd-ports@ is a reasonable alternative (since PostgreSQL is a port), but freebsd-questions@ is the best place to ask "mixed" questions, where the issue involves a combination of base system, ports, etc. However, you should be able to run the thing under gdb, or debug a corefile which was previously generated, and gain more information about what is going wrong. IMO, doing SQL query tracing and optimization is much more likely to produce tunable performance improvements than working at the DTrace level.... Regards, -- -Chuck