X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2FAC653351 for ; Mon, 18 Apr 2005 16:27:18 -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 51847-03 for ; Mon, 18 Apr 2005 19:27:09 +0000 (GMT) Received: from web51407.mail.yahoo.com (web51407.mail.yahoo.com [206.190.38.186]) by svr1.postgresql.org (Postfix) with SMTP id EE8BD5335C for ; Mon, 18 Apr 2005 16:27:07 -0300 (ADT) Received: (qmail 51231 invoked by uid 60001); 18 Apr 2005 19:27:08 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=2Cd1N7KdK60k0lVgqUfIYScDvN4/sKowzB0WFfH4wI9GESTZ7uvrllEmeixjFs9zeuztkFrbEZHzUm3Rc7cXEwPX+zKHiAkHYzjx0nJJZYZqxqzynuMIP/yghbjM4gcr5yzV6xpbw8wewsU8ONiS6PYC8pxBgp/+zkZr+Qm9ahA= ; Message-ID: <20050418192708.51229.qmail@web51407.mail.yahoo.com> Received: from [192.88.67.254] by web51407.mail.yahoo.com via HTTP; Mon, 18 Apr 2005 12:27:08 PDT Date: Mon, 18 Apr 2005 12:27:08 -0700 (PDT) From: Bill Chandler Subject: Question on vacuumdb To: pgsql-perform MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.972 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, LONGWORDS X-Spam-Level: * X-Archive-Number: 200504/431 X-Sequence-Number: 11828 All, If I run the command "vacuumdb mydb" I understand that it does some disk space recovery (but not as much as "vacuumdb --full mydb"). Question: if I run the command "vacuumdb --analyze mydb" does it still do the aforementioned disk space recovery AS WELL AS update query planning statistics? Or are those two completely separate operations requiring separate invocations of 'vacuumdb'. thanks, Bill __________________________________ Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! http://travel.yahoo.com/p-travelguide