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 D91269DC898 for ; Thu, 5 Jan 2006 08:23:21 -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 68050-07 for ; Thu, 5 Jan 2006 08:23:24 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B22F49DC882 for ; Thu, 5 Jan 2006 08:23:19 -0400 (AST) Received: from galagonx.fixdial.interware.hu (galagonx.fixdial.interware.hu [195.70.45.31]) by svr4.postgresql.org (Postfix) with ESMTP id 694605AF073 for ; Thu, 5 Jan 2006 12:23:22 +0000 (GMT) Received: from szballa.intra ([172.20.80.68]) by galagonx.fixdial.interware.hu with esmtp (Exim 3.36 #1 (Debian)) id 1EuU9H-0000mC-00 for ; Thu, 05 Jan 2006 13:23:19 +0100 Subject: Vacuum is needed or not? From: Szabolcs BALLA To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="=-PGvPIaeGobuDJIHIwAab" Date: Thu, 05 Jan 2006 13:23:18 +0100 Message-Id: <1136463798.4221.35.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=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200601/132 X-Sequence-Number: 20220 --=-PGvPIaeGobuDJIHIwAab 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 --=-PGvPIaeGobuDJIHIwAab 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 --=-PGvPIaeGobuDJIHIwAab--