X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B914D6E24 for ; Sun, 28 Aug 2005 13:46:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28980-01 for ; Sun, 28 Aug 2005 16:46:56 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 43580D6E11 for ; Sun, 28 Aug 2005 13:46:55 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7SGkqQr025203; Sun, 28 Aug 2005 12:46:52 -0400 (EDT) To: Aldor Cc: pgsql-admin@postgresql.org Subject: Re: VACUUM - Wow long should it take?! - Here are some test results In-reply-to: <4311DFD5.6000104@mediaroot.de> References: <4311DFD5.6000104@mediaroot.de> Comments: In-reply-to Aldor message dated "Sun, 28 Aug 2005 17:01:25 +0100" Date: Sun, 28 Aug 2005 12:46:52 -0400 Message-ID: <25202.1125247612@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.435 required=5 tests=[AWL=-0.422, PLING_QUERY=0.857] X-Spam-Level: X-Archive-Number: 200508/366 X-Sequence-Number: 18685 Aldor writes: > bgwriter_percent = 0 > bgwriter_maxpages = 0 Why did you do that? There's certainly nothing in the docs recommending disabling the bgwriter. > The duration of the VACUUM of tbl1 and tbl2 is okay - so how to speed up > now the VACUUM of tbl3? You have not showed us anything that would explain any speed differences between these tables. Maybe there was some difference in the data you loaded them with? regards, tom lane