X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 20B6952FC1 for ; Tue, 26 Jul 2005 04:43:48 -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 27497-09 for ; Tue, 26 Jul 2005 07:43:42 +0000 (GMT) Received: from moon.antora.ru (moon.antora.ru [83.222.21.34]) by svr1.postgresql.org (Postfix) with ESMTP id 6948052F53 for ; Tue, 26 Jul 2005 04:43:41 -0300 (ADT) Received: from [217.26.17.26] (helo=[10.0.0.72]) by moon.antora.ru with esmtpsa (TLSv1:DHE-RSA-AES256-SHA:256) (Exim 4.51 (FreeBSD)) id 1DxK6F-000EVe-Sr for pgsql-sql@postgresql.org; Tue, 26 Jul 2005 11:43:41 +0400 Message-ID: <42E5E90E.8090604@bankir.ru> Date: Tue, 26 Jul 2005 11:41:02 +0400 From: "Eugene E." User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050517) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: REINDEX DATABASE References: <42E521DF.4000804@rusa.at> <20050725174952.GA23263@wolff.to> In-Reply-To: <20050725174952.GA23263@wolff.to> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.365 tagged_above=0 required=5 tests=SUBJ_ALL_CAPS X-Spam-Level: X-Archive-Number: 200507/226 X-Sequence-Number: 22204 Hello Would you like to advice to use REINDEX DATABASE on regular basis ? if (yes) how it should be connected with VACUUM FULL ANALYZE which is run regularly ? (reindex before vacuum or vacuum before reindex?) else haw to determine _when_ to run REINDEX ? many thanks