Postgres Pro
Downloads
Home   >   mailing lists

Re: 3-days-long vacuum of 20GB table - Mailing list pgsql-performance

From Tom Lane
Subject Re: 3-days-long vacuum of 20GB table
Date
Msg-id 3630.1208538238@sss.pgh.pa.us
Whole thread Raw
In response to 3-days-long vacuum of 20GB table  ("Jeffrey Baker" <jwbaker@gmail.com>)
Responses Re: 3-days-long vacuum of 20GB table
List pgsql-performance
Tree view 
"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?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jeffrey Baker"
Date:
Subject: 3-days-long vacuum of 20GB table
Next
From: Greg Smith
Date:
Subject: Re: Strange behavior: pgbench and new Linux kernels