Re: Database is slow, vacuum hangs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Database is slow, vacuum hangs
Дата
Msg-id 1849.1015020724@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Database is slow, vacuum hangs  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-admin
"Nick Fankhauser" <nickf@ontko.com> writes:
>> If you haven't a clue, try attaching to each process with a debugger and
>> printing out the global variable debug_query_string.

> How do I do that?

Having identified the process PIDs, you can do

    gdb /path/to/postgres-executable

    gdb> attach PID
    gdb> p debug_query_string
    gdb> bt            -- might as well do this while you're here
    gdb> quit

This assumes you have gdb handy.  There is a way to do this with adb
too, but I don't use it enough to remember.

            regards, tom lane

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

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: Database is slow, vacuum hangs
Следующее
От: Zak Greant
Дата:
Сообщение: Re: PHP ODBC conflict