Re: Recovery will take 10 hours

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Recovery will take 10 hours
Дата
Msg-id 105.1145567988@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Recovery will take 10 hours  (Brendan Duddridge <brendan@clickspace.com>)
Ответы Re: Recovery will take 10 hours  (Brendan Duddridge <brendan@clickspace.com>)
Re: Recovery will take 10 hours  (Brendan Duddridge <brendan@clickspace.com>)
Список pgsql-performance
Brendan Duddridge <brendan@clickspace.com> writes:
> Do you mean do a kill -QUIT on the postgres process in order to
> generate a stack trace?

Not at all!  I'm talking about tracing the kernel calls it's making.
Depending on your platform, the tool for this is called strace,
ktrace, truss, or maybe even just trace.  With strace you'd do
something like

    strace -p PID-of-process 2>outfile
    ... wait 30 sec or so ...
    control-C

Not sure about the APIs for the others but they're probably roughly
similar ... read the man page ...

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Guido Neitzer
Дата:
Сообщение: Re: Performance decrease
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Recovery will take 10 hours