3-days-long vacuum of 20GB table

From: "Jeffrey Baker" <jwbaker(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: 3-days-long vacuum of 20GB table
Date: 2008-04-18 16:35:42
Message-ID: fd145f7d0804180935w7d0052degf79a9660b043c084@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2008-04-18 17:03:58 Re: 3-days-long vacuum of 20GB table
Previous Message Enrico Sirola 2008-04-18 14:38:05 Re: Performance increase with elevator=deadline