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

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

"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?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

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