Re: rebellious pg stats collector (reopened case)

From: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: rebellious pg stats collector (reopened case)
Date: 2008-12-22 13:58:59
Message-ID: 494F9D23.1040601@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance


> and see if its output changes when you start to trace it.
>
%cat test.c
#include <stdio.h>

int main() {
while(1) {
sleep(5);
printf("ppid = %d\n", getppid());
}
}

%gcc -o test test.c
%./test
ppid = 47653
ppid = 47653
ppid = 47653 # Started "truss -p 48864" here!
ppid = 49073
ppid = 49073
ppid = 49073

> Agreed, but we need to understand what the tools being used to
> investigate the problem are doing ...
>
Unfortunately, I'm not able to install strace:

# pwd
/usr/ports/devel/strace
# make
===> strace-4.5.7 is only for i386, while you are running amd64.
*** Error code 1

Stop in /usr/ports/devel/strace.

I'll happily install any trace tool, but have no clue which one would help.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laszlo Nagy 2008-12-22 13:59:32 Re: [ADMIN] rebellious pg stats collector (reopened case)
Previous Message Laszlo Nagy 2008-12-22 13:57:33 Re: [ADMIN] rebellious pg stats collector (reopened case)

Browse pgsql-performance by date

  From Date Subject
Next Message Laszlo Nagy 2008-12-22 13:59:32 Re: [ADMIN] rebellious pg stats collector (reopened case)
Previous Message Laszlo Nagy 2008-12-22 13:57:33 Re: [ADMIN] rebellious pg stats collector (reopened case)