| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2007-11-19 16:58:52 | Re: [GENERAL] Error while starting postgreSQL service |
| Previous Message | Bebarta, Simanchala | 2007-11-19 10:15:52 | Re: [GENERAL] Error while starting postgreSQL service |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | x asasaxax | 2007-11-19 11:17:04 | Postgre and XML |
| Previous Message | Bebarta, Simanchala | 2007-11-19 10:15:52 | Re: [GENERAL] Error while starting postgreSQL service |