Received: from sunpine.krs.ru (SunPine.krs.ru [195.161.16.37]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA28739 for ; Tue, 1 Jun 1999 03:50:35 -0400 (EDT) (envelope-from vadim@krs.ru) Received: from krs.ru (dune.krs.ru [195.161.16.38]) by sunpine.krs.ru (8.8.8/8.8.8) with ESMTP id PAA15781; Tue, 1 Jun 1999 15:45:55 +0800 (KRSS) Sender: root@sunpine.krs.ru Message-ID: <37538FB3.FD994CAB@krs.ru> Date: Tue, 01 Jun 1999 15:45:55 +0800 From: Vadim Mikheev Organization: OJSC Rostelecom (Krasnoyarsk) X-Mailer: Mozilla 4.5 [en] (X11; I; FreeBSD 3.0-RELEASE i386) X-Accept-Language: ru, en MIME-Version: 1.0 To: Remigiusz Sokolowski CC: Tom Lane , pgsql-sql@postgreSQL.org Subject: Re: [SQL] indexes References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Remigiusz Sokolowski wrote: > > Yea - I've just done VACUUM during my efforts to speed up query (btw. > should I do something with notices from VACUUM like that one: > NOTICE: Ind binds_idx: NUMBER OF INDEX' TUPLES (4) IS NOT THE SAME AS > HEAP' (1787)) Ops. Re-build binds_idx! And use latest 6.5 snapshot if you use 6.5 beta... Vadim