On Fri, 27 Jun 2008 18:04:19 -0400 Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > hubert depesz lubaczewski <depesz@xxxxxxxxxx> writes: > > friend asked me to setup replication on their machines, and i noticed > > that one of cpus (2 quad xeons) is used to 100%: > > pgsql 58241 99.0 0.2 22456 7432 ?? Rs Thu10AM 1530:35.93 postgres: stats collector process (postgres) > > Hmm, we had some problems with the stats collector going nuts a couple > of versions ago; maybe you've found another way to trigger that. > Anything unusual about this DB (lots of tables, for instance)? > Can you try strace and/or gdb to figure out what the collector is doing? Just in case you're not a FreeBSD expert, it's ktrace on FreeBSD. strace is the Linux equivalent. -- Bill Moran <wmoran@xxxxxxxxxxxxxxxxxxxxxxx>
