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 > 3-days-long vac...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 8 Topic 4003 of 4156
Post > Topic >>

3-days-long vacuum of 20GB table

by jwbaker@[EMAIL PROTECTED] ("Jeffrey Baker") Apr 18, 2008 at 09:35 AM

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)?

current_query: VACUUM reuters.value
query_start: 2008-04-15 20:12:48.806885-04
think=# select * from pg_class where relname = 'value';
-[ RECORD 1 ]--+---------------------------------
relname        | value
relfilenode    | 191425
relpages       | 1643518
reltuples      | 1.37203e+08
# find -name 191425\*
../16579/191425
../16579/191425.1
../16579/191425.10
../16579/191425.11
../16579/191425.12
../16579/191425.13
../16579/191425.14
../16579/191425.15
../16579/191425.16
../16579/191425.17
../16579/191425.18
../16579/191425.19
../16579/191425.2
../16579/191425.3
../16579/191425.4
../16579/191425.5
../16579/191425.6
../16579/191425.7
../16579/191425.8
../16579/191425.9
# vmstat 1
procs -----------memory---------- ---swap-- -----io---- -system--
----cpu----
 r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id
wa
 0  1  30336  46264     60 7882356    0    0   250   299    1    1  6  2
87  5
 0  1  30336  47412     60 7881308    0    0  2896    48  944 4861  3  2
71 24
 0  2  30336  46696     60 7882188    0    0   816     4  840 5019  1  0
75 24
 0  1  30336  49228     60 7879868    0    0  1888   164  971 5687  1  1
74 24
 0  1  30336  49688     60 7878916    0    0  2640    48 1047 5751  1  0
75 23
 autovacuum                      | on
 autovacuum_vacuum_cost_delay    | -1
 autovacuum_vacuum_cost_limit    | -1
 vacuum_cost_delay               | 0
 vacuum_cost_limit               | 200
 vacuum_cost_page_dirty          | 20
 vacuum_cost_page_hit            | 1
 vacuum_cost_page_miss           | 10

-- 
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
tan13V112 Sun Jul 6 22:10:52 CDT 2008.