Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 2D89A633876 for ; Sun, 15 Aug 2010 12:24:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 17183-04 for ; Sun, 15 Aug 2010 15:24:31 +0000 (UTC) X-Greylist: delayed 00:21:13.954632 by SQLgrey-1.7.6 Received: from out.mail.amis.hr (out.mail.amis.hr [194.146.109.198]) by mail.postgresql.org (Postfix) with ESMTP id 05492633067 for ; Sun, 15 Aug 2010 12:24:30 -0300 (ADT) Received: from out1.fsec.srv.amis.hr (out.fsec.srv.amis.hr [192.168.103.43]) by out.mail.amis.hr (Postfix) with ESMTP id 0B2B866855C for ; Sun, 15 Aug 2010 17:03:14 +0200 (CEST) Received: from pps.filterd (out1 [127.0.0.1]) by out1.fsec.srv.amis.hr (8.14.3/8.14.3) with SMTP id o7FF3DYO008003 for ; Sun, 15 Aug 2010 17:03:13 +0200 Received: from smtp.amis.hr (smtp.srv.amis.hr [192.168.103.39]) by out1.fsec.srv.amis.hr with ESMTP id qn5tq08nw-1 for ; Sun, 15 Aug 2010 17:03:13 +0200 Received: from [192.168.10.1] (cpe-188-129-66-199.dynamic.amis.hr [188.129.66.199]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: splivalo) by smtp.amis.hr (Postfix) with ESMTPSA id 6C9DB384 for ; Sun, 15 Aug 2010 17:03:13 +0200 (CEST) Message-ID: <4C6801B4.5050202@megafon.hr> Date: Sun, 15 Aug 2010 17:03:16 +0200 From: Mario Splivalo User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.11) Gecko/20100713 Thunderbird/3.0.6 MIME-Version: 1.0 To: pgsql-testers@postgresql.org Subject: vacuum in pg9beta4 much slower than in 8.4 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.0.10011, 1.0.148, 0.0.0000 definitions=2010-08-15_06:2010-08-15, 2010-08-15, 1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=46 spamscore=46 ipscore=0 phishscore=0 bulkscore=1 adultscore=4 classifier=spam adjust=0 reason=mlx engine=6.0.2-1004200000 definitions=main-1008150092 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201008/12 X-Sequence-Number: 167 I think this is ok, but I'd just like a confirmation. I have a db cluster with 6 databases, totaling around 6 GB of data. In postgres 8.4 subsequent runs of 'vacuumdb -afvz' takes around 55 seconds (average from 10 runs). 'vacuumdb -avz' takes around 40 seconds (average from 10 runs). However, in postgres 9.0beta4, 'vacuumdb -avz' takes around 2 minutes (average from 10 runs), and 'vacuumdb -afvz' takes around 12 minutes (average from 4 runs). I understand that VACUUM FULL in 9.0 copies all the data, but is it OK that plain vacuum in 9.0 is slower than in 8.4? Mike