Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 2C2EA2E2E5D for ; Mon, 19 Nov 2007 13:03:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 39835-06 for ; Mon, 19 Nov 2007 12:59:03 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.234]) by postgresql.org (Postfix) with ESMTP id D54F22E2DE1 for ; Mon, 19 Nov 2007 12:59:02 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 58so681614wri for ; Mon, 19 Nov 2007 08:59:02 -0800 (PST) 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=xpva97vbPVN4l3F6pJf3ZdHJYLWhRzr2vnPAbJLkMjM=; b=uWg0XiJPKnBlllwJBa+EAEsXiMjMNPHp4vUQoC/0+F4lAPuCu/RQXw8OgOLHzkt0EdzVYYJSjjjvEx87veDhLE/YxhWCQ/RJf3hOq2ytA//8/MufaVOwuiH9r6njYxy3U4dK+160Vrnkiy/4aqoyR+3ULjKRjXWhRjzdzeWpRtA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=XXv+tUJh3ryVKjCfg25lLct32BhSyYtPv5SeCssi+OtDrKE4V2lqIQ/9H0tHvUVqz5vO1tzFKQOJcdpV6dTEyR2ehJiuUqFKa3EBT9nV4P9cLZBVm0R2XSBEeJu8TTeijvpZgCZvNrKJVBO8MFblMRx6LFQ04wYMpntOsVzMTDY= Received: by 10.115.60.1 with SMTP id n1mr1402167wak.1195491537596; Mon, 19 Nov 2007 08:58:57 -0800 (PST) Received: by 10.114.171.20 with HTTP; Mon, 19 Nov 2007 08:58:52 -0800 (PST) Message-ID: Date: Mon, 19 Nov 2007 10:58:52 -0600 From: "Scott Marlowe" To: "Bebarta, Simanchala" Subject: Re: [GENERAL] Error while starting postgreSQL service Cc: "Richard Huxton" , "PG-General Mailing List" , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47415B2B.1030007@archonet.com> <474160F0.4060003@archonet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/177 X-Sequence-Number: 27420 On Nov 19, 2007 4:15 AM, Bebarta, Simanchala wrote: > Yes, when I set the value to 1300 MB, everything goes fine. Any value > higher than this value does not allow me to start the service. Please don't top post. Anyway, are you sure that increasing shared_buffers that high is helping? There's some evidence that windows pgsql can't use shared_buffer settings that high efficiently. Have you tested shared_buffer settings starting low and working you way up and seen a steady increase in performance? Or are you just guessing that larger shared_buffer = better performance? I'm guessing that it's a limitation of windows and pgsql that you're running into. If you want to run a large memory postgresql database server with lots of load, I highly recommend using unix as the underlying OS, as pgsql is far better tested and supported there.