Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 18 Apr 2008 13:03:58 -0400
- Message-id: <3630(dot)1208538238(at)sss(dot)pgh(dot)pa(dot)us>
"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
- Follow-Ups:
- Re: 3-days-long vacuum of 20GB table
- From: Jeffrey Baker
- Re: 3-days-long vacuum of 20GB table
- References:
- 3-days-long vacuum of 20GB table
- From: Jeffrey Baker
- 3-days-long vacuum of 20GB table
- Prev by Date: 3-days-long vacuum of 20GB table
- Next by Date: Re: Strange behavior: pgbench and new Linux kernels
- Previous by thread: 3-days-long vacuum of 20GB table
- Next by thread: Re: 3-days-long vacuum of 20GB table
- Indexes: