Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-performance by date

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group