X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0CE249DCAD4 for ; Thu, 5 Jan 2006 09:12:01 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76157-08 for ; Thu, 5 Jan 2006 09:12:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from galagonx.fixdial.interware.hu (galagonx.fixdial.interware.hu [195.70.45.31]) by postgresql.org (Postfix) with ESMTP id C95819DC882 for ; Thu, 5 Jan 2006 09:11:58 -0400 (AST) Received: from szballa.intra ([172.20.80.68]) by galagonx.fixdial.interware.hu with esmtp (Exim 3.36 #1 (Debian)) id 1EuUuP-0001DL-00 for ; Thu, 05 Jan 2006 14:12:01 +0100 Subject: Vacuum is needed or not? From: Szabolcs BALLA To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="=-7m99+ftlNzcuzR9bAJqi" Date: Thu, 05 Jan 2006 14:12:01 +0100 Message-Id: <1136466721.4221.39.camel@bh> Mime-Version: 1.0 X-Mailer: Evolution 2.0.4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[AWL=-0.001, HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200601/69 X-Sequence-Number: 20157 --=-7m99+ftlNzcuzR9bAJqi Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi, How do I know vacuum is need or not? I mean, are there any query to know status of statistics, tables, indexes, etc? (7.4.7) Our database size bigger than just go and do it. :( Thanks, Szabek --=-7m99+ftlNzcuzR9bAJqi Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit Hi,

How do I know vacuum is need or not? I mean, are there any query to know status of statistics, tables, indexes, etc?
(7.4.7)
Our database size bigger than just go and do it. :(

Thanks,
Szabek --=-7m99+ftlNzcuzR9bAJqi--