X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7B4389DCC6A for ; Wed, 8 Feb 2006 19:31:15 -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 79387-06 for ; Wed, 8 Feb 2006 19:31:17 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 4BBA49DCBF0 for ; Wed, 8 Feb 2006 19:31:13 -0400 (AST) Received: from gw.proximity.com.au (147-68-185-210.rev.techex.net.au [210.185.68.147]) by svr4.postgresql.org (Postfix) with ESMTP id A5B465AF05C for ; Wed, 8 Feb 2006 23:31:16 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by gw.proximity.com.au (Postfix) with ESMTP id BE7531EFCF5; Thu, 9 Feb 2006 10:31:10 +1100 (EST) Received: from gw.proximity.com.au ([127.0.0.1]) by localhost (gw [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27959-08; Thu, 9 Feb 2006 10:31:09 +1100 (EST) Received: from [192.168.128.103] (bee.proximity.com.au [192.168.128.103]) by gw.proximity.com.au (Postfix) with ESMTP id AF9A61EFCF3; Thu, 9 Feb 2006 10:31:09 +1100 (EST) Message-ID: <43EA7F3D.7050306@proximity.com.au> Date: Thu, 09 Feb 2006 10:31:09 +1100 From: Tim Allen User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Markus Schaber Cc: Mahesh Shinde , pgsql-performance@postgresql.org Subject: Re: Default autovacuum settings too conservative References: <20060201211633.GM95850@pervasive.com> <43E12A03.6070906@zeut.net> <20060207050545.GZ1240@pervasive.com> <20060207072621.GI13592@pervasive.com> <43E89506.40903@logix-tt.com> <20060208010339.GT38134@pervasive.com> <43E94E42.3080605@pws.com.au> <43E9D066.40101@logix-tt.com> <002c01c62ca4$3159b860$dd0aa8c0@codecindia.com> <43E9F440.1080001@logix-tt.com> In-Reply-To: <43E9F440.1080001@logix-tt.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at proximity.com.au X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/73 X-Sequence-Number: 17059 Markus Schaber wrote: >>Does vacuum improves the performance of the database search.. As if now I >>have a table who is having a records 70 lac and daily appx 10-15 thousand >>rows get added. so please let me know which type of vacuum I should prefer. >>I am accessing a data using java application which is hosted on the same >>database server. > > I don't know what "70 lac" means. One lac (also spelt "lakh") is one hundred thousand. And one crore is ten million. Indians count differently from the rest of the world :-). Tim -- ----------------------------------------------- Tim Allen tim@proximity.com.au Proximity Pty Ltd http://www.proximity.com.au/