Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id C3DBF2E106F; Mon, 19 Nov 2007 06:34:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 65595-05; Mon, 19 Nov 2007 06:33:29 -0400 (AST) Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132]) by postgresql.org (Postfix) with ESMTP id EDDF52E0FEB; Mon, 19 Nov 2007 06:34:00 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay05.plus.net with esmtp (Exim) id 1Iu3ww-0004LD-Ia; Mon, 19 Nov 2007 10:33:55 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id C6D7227405F; Mon, 19 Nov 2007 10:33:53 +0000 (GMT) Message-ID: <47416691.6020608@archonet.com> Date: Mon, 19 Nov 2007 10:33:53 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: "Bebarta, Simanchala" CC: PG-General Mailing List , pgsql-admin@postgresql.org Subject: Re: [GENERAL] Error while starting postgreSQL service References: <47415B2B.1030007@archonet.com> <474160F0.4060003@archonet.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/176 X-Sequence-Number: 27419 Bebarta, Simanchala wrote: >> >> Does the problem go away when you put shared_buffers back to a lower >> number? >> > 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. It's quite possible that you can't go any higher (I don't know enough about Windows' memory handling). It's quite possible you don't want to anyway. Don't forget, you want to allow space for the following: - Windows itself - Other applications - Each backend of PostgreSQL will need its own memory when running queries. - Filesystem caching. PostgreSQL isn't like some other RDBMS where you dedicate a big block of memory just to it. -- Richard Huxton Archonet Ltd