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 AF8633A53BB for ; Wed, 1 Dec 2004 02:05:24 +0000 (GMT) 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 11551-10 for ; Wed, 1 Dec 2004 02:05:16 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 4CA793A52D0 for ; Wed, 1 Dec 2004 02:05:18 +0000 (GMT) Received: from wp2000 ([157.157.176.239] [157.157.176.239]) by quasar.skima.is; Wed, 1 Dec 2004 02:05:18 Z Message-Id: <017c01c4d74a$90805de0$0100000a@wp2000> From: "gnari" To: "BBI Edwin Punzalan" , References: <004b01c4d748$23ccad90$b400a8c0@bluebamboo.ph> Subject: Re: FW: Index usage Date: Wed, 1 Dec 2004 02:07:52 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/3 X-Sequence-Number: 9378 From: "BBI Edwin Punzalan" > > Hi, what do you mean by increasing the statistics on the date column? alter table chatlogs alter column date set statistics 300; analyze chatlogs; > > > Our version is 7.2.1 > > > > upgrade time ? > > We never had any upgrade on it. 7.2 is a bit dated now that 8.0 is in beta if you want to stay with 7.2, you should at least upgrade to the latest point release (7.2.6 ?), as several serious bugs have been fixed gnari