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 6256.1208545748@sss.pgh.pa.us
Whole thread Raw
In response to Re: 3-days-long vacuum of 20GB table  ("Jeffrey Baker" <jwbaker@gmail.com>)
List pgsql-performance
Tree view 
"Jeffrey Baker" <jwbaker@gmail.com> writes:
> I increased it to 1GB, restarted the vacuum, and system performance
> seems the same.  The root of the problem, that an entire CPU is in the
> iowait state and the storage device is doing random i/o, is unchanged:

Yeah, but you just reduced the number of index scans that will be needed
by a factor of 1GB/16MB.  Hang in there ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: 3-days-long vacuum of 20GB table
Next
From: Jesper Krogh
Date:
Subject: Re: Message queue table..