Re: vacuum taking an unusually long time

Поиск
Список
Период
Сортировка
От Mason Hale
Тема Re: vacuum taking an unusually long time
Дата
Msg-id 8bca3aa10807160826r729c5ae3pe720af5e2eba44e0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: vacuum taking an unusually long time  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: vacuum taking an unusually long time  ("Mason Hale" <masonhale@gmail.com>)
Список pgsql-general
Here's some of the strace output:

select(0, NULL, NULL, NULL, {0, 10000}) = 0 (Timeout)
semop(9895945, 0x7fff1321db70, 1)       = 0
read(72, "\233\7\0\0H\207f2\1\0\1\0`\0\0 \0 \4 \0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
read(72, "!\5\0\0\370\277\371\247\1\0\1\0\214\0\330\23\0 \4 \0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
read(72, "}\4\0\0h]\333\217\1\0\1\0X\0\310\v\0 \4 \0\0\0\0\0\0\0\0X\235H\5"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
read(72, "}\4\0\0(\260\333\217\1\0\1\0\\\0\200\v\0 \4 \0\0\0\0\0\0\0\0\0\0\0\0"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
read(72, "}\4\0\0p\305\333\217\1\0\1\0\\\0p\v\0 \4 \0\0\0\0\370\235\20\4\0\0\0\0"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
read(72, "!\5\0\0\10\330\371\247\1\0\1\0P\0\240\10\0 \4 \0\0\0\0\0\0\0\0\360\234 \6"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
read(72, "\233\7\0\0\340\212f2\1\0\1\0t\0(\35\0 \4 \0\0\0\0\0\0\0\0(\235\250\5"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
read(72, "\24\10\0\0\230\333\372\207\1\0\1\0`\0\330\n\0 \4 \0\0\0\0X\220@\4\7\0\1\0"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
semop(9830407, 0x7fff1321db90, 1)       = 0
read(72, "\362\n\0\0H\316,r\1\0\1\0\204\0P\r\0 \4 _\17L\21x\235\20\5\5\0\1\0"..., 8192) = 8192
select(0, NULL, NULL, NULL, {0, 80000}) = 0 (Timeout)
read(72, "\177\5\0\0\300\317A\276\1\0\1\0p\0\210\1\0 \4 \0\0\0\0\26\0\1\0\30\235\310\5"..., 8192) = 8192

All those "select(0, NULL, NULL, NULL, {0, 10000}) = 0 (Timeout)" commands sure look suspicious.

Any thoughts?

Mason

On Tue, Jul 15, 2008 at 10:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Mason Hale" <masonhale@gmail.com> writes:
> The longest running vacuum has been running more than 6 days at this point.

Is it actually *doing* anything, or is it just blocked waiting for
someone else?  strace or local equivalent would be the most definitive
way to check.

                       regards, tom lane

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

Предыдущее
От: Viktor Rosenfeld
Дата:
Сообщение: Re: UPDATE runs slow in a transaction
Следующее
От: "Mason Hale"
Дата:
Сообщение: Re: vacuum taking an unusually long time