Re: 3-days-long vacuum of 20GB table

Поиск
Список
Период
Сортировка
От Jeffrey Baker
Тема Re: 3-days-long vacuum of 20GB table
Дата
Msg-id fd145f7d0804181032w5dd56caj608866297120984a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 3-days-long vacuum of 20GB table  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: 3-days-long vacuum of 20GB table  ("Jeffrey Baker" <jwbaker@gmail.com>)
Список pgsql-performance
On Fri, Apr 18, 2008 at 10:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Jeffrey Baker" <jwbaker@gmail.com> writes:
>  > This autovacuum has been hammering my server with purely random i/o
>  > for half a week.  The table is only 20GB and the i/o subsystem is good
>  > for 250MB/s sequential and a solid 5kiops.  When should I expect it to
>  > end (if ever)?
>
>  What have you got maintenance_work_mem set to?  Which PG version
>  exactly?

This is 8.1.9 on Linux x86_64,

# show maintenance_work_mem ;
 maintenance_work_mem
----------------------
 16384

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Strange behavior: pgbench and new Linux kernels
Следующее
От: "Jeffrey Baker"
Дата:
Сообщение: Re: 3-days-long vacuum of 20GB table