Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 947262E0035 for ; Sun, 23 Mar 2008 00:01:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62565-09 for ; Sun, 23 Mar 2008 00:01:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by postgresql.org (Postfix) with ESMTP id C86372E002D for ; Sun, 23 Mar 2008 00:01:33 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so2618441waf.5 for ; Sat, 22 Mar 2008 20:01:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=AEYyiOri6I4E4ZJ/lL35dv3qFHeVNT2AjBOh6KRZXG8=; b=lk3nan/JM7ekfzUXTIPD+8z2RKQ5iXSUIqWqD96SMtR66Zhh2d6CxPpe8SM5EbpgBuKWVOv1c12USxFef3DibiuljBvH60ZnpP9vKIIwHZMZsNvitIbv9+c5PkEiBE12QDHi20yquQM5HPPCjFQ37WaYsZpc7mbbgrQvEqOwx/c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Yn3RnoWaokXPIF2WM03++zvzWWQCyzLAO+WxQD2PZS0BYV1y3rL2Kj6Bh/Phmln5PtS+pRTUKNBEbJl5DrDM5jiEYnua5yAIAF1ekzKX9O0JbfFaNpOP2xn3vy4oVti9N6VkAINLAGCXBZjxYqIsUjEZ/BVuRhjX/UxV7pN7z8M= Received: by 10.114.37.1 with SMTP id k1mr9074316wak.6.1206241293186; Sat, 22 Mar 2008 20:01:33 -0700 (PDT) Received: by 10.115.95.11 with HTTP; Sat, 22 Mar 2008 20:01:33 -0700 (PDT) Message-ID: Date: Sat, 22 Mar 2008 21:01:33 -0600 From: "Scott Marlowe" To: "Aftab Alam" Subject: Re: Postgres Performance Cc: pgsql-admin@postgresql.org In-Reply-To: <-4989057442942149499@unknownmsgid> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <-4989057442942149499@unknownmsgid> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/186 X-Sequence-Number: 28669 On Wed, Mar 19, 2008 at 11:38 PM, Aftab Alam wrote: > > Dear All, > > I am using postgres 7.0 with linux with 15 GB of database & 3 gb > of RAM. > > Can anyone suggest what is the best setting for postgres. I am using > postgres as web db. If you really are running 7.0 you need to look at upgrading. That version has known data eating bugs that will not be fixed.