Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: [ADMIN] [GENERAL] Error while starting postgreSQL service

From: Richard Huxton <dev(at)archonet.com>
Date: Mon Nov 19 2007 - 05:33:53 EST


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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Received on Mon Nov 19 05:35:32 2007

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 20:12:37 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library