Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 88451476148 for ; Fri, 4 Oct 2002 04:00:26 -0400 (EDT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by postgresql.org (Postfix) with ESMTP id D1A59476082 for ; Fri, 4 Oct 2002 04:00:24 -0400 (EDT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id g9481rO29203 for ; Fri, 4 Oct 2002 13:31:53 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id g9481rv29188; Fri, 4 Oct 2002 13:31:53 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org, pgsql-general , "pankaj M. Tolani" Date: Fri, 04 Oct 2002 13:30:54 +0530 MIME-Version: 1.0 Subject: Re: [HACKERS] Large databases, performance Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3D9D980E.30447.102C03@localhost> In-reply-to: References: <3D9CBAD7.23509.A908C61@localhost> X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/173 X-Sequence-Number: 31172 On 3 Oct 2002 at 18:53, Manfred Koizar wrote: > On Thu, 03 Oct 2002 21:47:03 +0530, "Shridhar Daithankar" > wrote: > >I believe that was vacuum analyze only. > > Well there is > > VACUUM [tablename]; > > and there is > > ANALYZE [tablename]; > > And > > VACUUM ANALYZE [tablename]; > > is VACUUM followed by ANALYZE. I was using vacuum analyze. Good that you pointed out. Now I will modify the postgresql auto vacuum daemon that I wrote to analyze only in case of excesive inserts. I hope that's lighter on performance compared to vacuum analyze.. Bye Shridhar -- Mix's Law: There is nothing more permanent than a temporary building. There is nothing more permanent than a temporary tax.