Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id BFCDA2E0050 for ; Fri, 18 Apr 2008 13:35:49 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 98706-09 for ; Fri, 18 Apr 2008 13:35:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.181]) by developer.postgresql.org (Postfix) with ESMTP id 9F6852E0044 for ; Fri, 18 Apr 2008 13:35:43 -0300 (ADT) Received: by el-out-1112.google.com with SMTP id j27so282435elf.23 for ; Fri, 18 Apr 2008 09:35:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=wgsIvlRFBD3REd819+vhA7leB3dWrOBsUWrvb2++eYA=; b=xBV4D41K7dDk7gkMgRl2OUlEmX/eVSY13spR9J6qmkhYOP0S3Lo3Mt29W7H3DqfAN8phCMSYcI8EBMXTfA71N7QaxW0jM0IZqbep8w/JDEaST7YXyr1svC62dbPd02eSAuiaylepGRk4V9Sz7R7XgBspO+ceI7hIWtoCWkXvBKw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=o8dSsJdSCMC9u+cZniUVFwxIPLpd84cmPly6alrK4vv3DfRm1SjThEqrvosDKWu1LBBwHcOn4wq3bn8lLHpAgTdovijQzrDZbBeilGcLg2Y/X0p4TbRk8HyAPGCDTBh5WSxAsMqP0CM725rjVVrrWvyAybTqXq2iqzmTD++crhQ= Received: by 10.142.158.17 with SMTP id g17mr691570wfe.234.1208536542455; Fri, 18 Apr 2008 09:35:42 -0700 (PDT) Received: by 10.142.185.20 with HTTP; Fri, 18 Apr 2008 09:35:42 -0700 (PDT) Message-ID: Date: Fri, 18 Apr 2008 09:35:42 -0700 From: "Jeffrey Baker" To: pgsql-performance@postgresql.org Subject: 3-days-long vacuum of 20GB table MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/269 X-Sequence-Number: 29762 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