Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: 3-days-long...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 8 Topic 4003 of 4296
Post > Topic >>

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

by tgl@[EMAIL PROTECTED] (Tom Lane) Apr 18, 2008 at 01:03 PM

"Jeffrey Baker" <jwbaker@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
 




 8 Posts in Topic:
3-days-long vacuum of 20GB table
jwbaker@[EMAIL PROTECTED]  2008-04-18 09:35:42 
Re: 3-days-long vacuum of 20GB table
tgl@[EMAIL PROTECTED] (T  2008-04-18 13:03:58 
Re: 3-days-long vacuum of 20GB table
jwbaker@[EMAIL PROTECTED]  2008-04-18 10:32:05 
Re: 3-days-long vacuum of 20GB table
jwbaker@[EMAIL PROTECTED]  2008-04-18 10:34:57 
Re: 3-days-long vacuum of 20GB table
heikki@[EMAIL PROTECTED]   2008-04-19 08:57:11 
Re: 3-days-long vacuum of 20GB table
jwbaker@[EMAIL PROTECTED]  2008-04-18 10:54:24 
Re: 3-days-long vacuum of 20GB table
alvherre@[EMAIL PROTECTED  2008-04-18 14:24:22 
Re: 3-days-long vacuum of 20GB table
tgl@[EMAIL PROTECTED] (T  2008-04-18 15:09:08 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Sep 8 3:04:29 CDT 2008.