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 Hackers > Re: XIDs and bi...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 9 Topic 9343 of 10114
Post > Topic >>

Re: XIDs and big boxes again ...

by jd@[EMAIL PROTECTED] ("Joshua D. Drake") May 11, 2008 at 10:10 AM

Hans-Juergen Schoenig wrote:

>>             regards, tom lane
>>   
> 
> 
> overhead is not an issue here - if i lose 10 or 15% i am totally fine as

> long as i can reduce vacuum overhead to an absolute minimum.
> overhead will vary with row sizes anyway - this is not the point.

I am not buying this argument. If you have a 5TB database, I am going to 
assume you put it on enterprise class hardware. Enterprise class 
hardware can handle the I/O required to appropriately run vacuum.

We have a customer that is constantly running 5 autovacuum workers on 
only 28 spindles. We are in the process of upgrading them to 50 spindles 
at which point I will likely try 10 autovacuum workers.

> 
> the point is that you don't want to potentially vacuum a table when only

> a handful of records has been changed.

Right, generally speaking 20% is reasonable, although I tend to be much 
more aggressive and try to keep it at 10%.

Sincerely,

Joshua D. Drake


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




 9 Posts in Topic:
XIDs and big boxes again ...
postgres@[EMAIL PROTECTED  2008-05-11 12:05:44 
Re: XIDs and big boxes again ...
stark@[EMAIL PROTECTED]   2008-05-11 12:22:57 
Re: XIDs and big boxes again ...
tgl@[EMAIL PROTECTED] (T  2008-05-11 12:46:51 
Re: XIDs and big boxes again ...
postgres@[EMAIL PROTECTED  2008-05-11 18:50:42 
Re: XIDs and big boxes again ...
tgl@[EMAIL PROTECTED] (T  2008-05-11 13:01:49 
Re: XIDs and big boxes again ...
jd@[EMAIL PROTECTED] (&q  2008-05-11 10:10:40 
Re: XIDs and big boxes again ...
postgres@[EMAIL PROTECTED  2008-05-12 09:05:54 
Re: XIDs and big boxes again ...
stark@[EMAIL PROTECTED]   2008-05-12 09:37:24 
Re: XIDs and big boxes again ...
matthew@[EMAIL PROTECTED]  2008-05-12 13:55:45 

Post A Reply:
  Go here to Signup

AddThis Feed Button


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

Contact
tan12V112 Sun Sep 7 1:41:57 CDT 2008.