Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 1D06E9FBB72 for ; Thu, 22 Mar 2007 10:34:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 00775-09 for ; Thu, 22 Mar 2007 10:34:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.186]) by postgresql.org (Postfix) with ESMTP id 387619FB756 for ; Thu, 22 Mar 2007 10:34:27 -0300 (ADT) Received: by mu-out-0910.google.com with SMTP id g7so1049156muf for ; Thu, 22 Mar 2007 06:34:25 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:content-disposition:from:to:subject:date:user-agent:mime-version:content-type:content-transfer-encoding:message-id; b=UEN2IYu6kcU7ua/OI5OUB2rT2iGJ1JBBRP1Ajmi6UP2/XDRWX402m3W6vGMruhcNXIavfBt7pmCAUDy1WimO9q9d82xqUeqr/7FvpX/MFiEix36OvCTUocldYR6gzK3UD/OjfivhuPop0GkssRkJdtQ6VfS2NHt9HHh1KRHdwfY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:content-disposition:from:to:subject:date:user-agent:mime-version:content-type:content-transfer-encoding:message-id; b=IfHpz3JUNhiZRt07QIa+tF9uWt7z8+cb9CWJs2FvpPESTTuFOWTaADAFvv3+E54g31oSSx4eHB22u34hbkJ5Il2x3YWhMWYW3MhIJArMQ+ztJohrMAcfeWJelk5jZwegHTdTvlU1oZusgwJZ08hQXb904f2YzH4H7Wvj1LeCgTg= Received: by 10.82.155.10 with SMTP id c10mr4136931bue.1174570465438; Thu, 22 Mar 2007 06:34:25 -0700 (PDT) Received: from ?192.168.18.160? ( [194.206.227.18]) by mx.google.com with ESMTP id y34sm7786899iky.2007.03.22.06.34.24; Thu, 22 Mar 2007 06:34:24 -0700 (PDT) Content-Disposition: inline From: Dimitri To: pgsql-performance@postgresql.org Subject: Parallel Vacuum Date: Thu, 22 Mar 2007 14:35:53 +0100 User-Agent: KMail/1.9.3 MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200703221435.54408.dimitrik.fr@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/316 X-Sequence-Number: 23721 Folks, is there any constrains/problems/etc. to run several vacuum processes in parallel while each one is 'vaccuming' one different table? Example: vacuum -d db1 -t table1 & vacuum -d db1 -t table2 & vacuum -d db1 -t table3 & wait (sorry if it was already asked, but I did not find an explicit answer in archives) Thanks for any inputs! Rgds, -Dimitri