Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Error while starting postgreSQL service

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Bebarta, Simanchala" <Simanchala(dot)Bebarta(at)in(dot)unisys(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] Error while starting postgreSQL service
Date: 2007-11-19 10:33:53
Message-ID: 47416691.6020608@archonet.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2007-11-19 16:58:52
Subject: Re: [GENERAL] Error while starting postgreSQL service
Previous:From: Bebarta, SimanchalaDate: 2007-11-19 10:15:52
Subject: Re: [GENERAL] Error while starting postgreSQL service

pgsql-general by date

Next:From: x asasaxaxDate: 2007-11-19 11:17:04
Subject: Postgre and XML
Previous:From: Bebarta, SimanchalaDate: 2007-11-19 10:15:52
Subject: Re: [GENERAL] Error while starting postgreSQL service

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group