Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 14 Dec 2010 23:11:10 -0800
From:      Chuck Swiger <cswiger@mac.com>
To:        Dave Pooser <dave-freebsd@pooserville.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: PostgreSQL + 8.1 RELEASE + DTrace = pain?
Message-ID:  <77F6EE21-0872-4B6F-A534-07911A520FAB@mac.com>
In-Reply-To: <C92DA7BE.92C20%dave-freebsd@pooserville.com>
References:  <C92DA7BE.92C20%dave-freebsd@pooserville.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?77F6EE21-0872-4B6F-A534-07911A520FAB>