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

From: "Jeffrey Baker" <jwbaker(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 3-days-long vacuum of 20GB table
Date: 2008-04-18 17:32:05
Message-ID: fd145f7d0804181032w5dd56caj608866297120984a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Apr 18, 2008 at 10:03 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Jeffrey Baker" <jwbaker(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeffrey Baker 2008-04-18 17:34:57 Re: 3-days-long vacuum of 20GB table
Previous Message Greg Smith 2008-04-18 17:19:09 Re: Strange behavior: pgbench and new Linux kernels