|
|||||||||||
|
Re: [ADMIN] [GENERAL] Error while starting postgreSQL service
From: Richard Huxton <dev(at)archonet.com>
Date: Mon Nov 19 2007 - 05:33:53 EST
>> >> 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.
- 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 settingsReceived 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 |
||||||||||
|
|||||||||||