Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?
Date
Msg-id 20080628093524.GB25484@depesz.com
Whole thread Raw
In response to Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?  (Rodrigo Gonzalez <rjgonzale@gmail.com>)
Responses Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
On Sat, Jun 28, 2008 at 02:22:26AM -0300, Rodrigo Gonzalez wrote:
> So, read man page, and at least ktrace -C and read the output at
> ktrace.out file.

ok, i've read it and didn't understand. it says how to disable tracing
but it doesn't say anything about enabling tracing.

yesterday ktrace -p <pid> produced output, and today it generated empty
file.

so - apparently it's much more complicated than linux strace, and since
i generally never use bsd, i i'm not really interested in learning what
to do in this system to get trace. the only problem is that there
definitelly is some kind of problem in stats collector on bsd, but i'm
not able to help diagnose it at this moment.

Best regards,

depesz


pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: freebsd + postgresql 8.3.3 = 100% of cpu usage on stats collector?
Next
From: Tom Lane
Date:
Subject: Re: query planner weirdness?