Re: Config Changes Broke Postgres Service (Windows)

On 28 May 2010, at 15:40, Tom Wilcox wrote:

> Hi,
>
> I am fighting with Postgres on a 64-bit Windows (Server 2008) machine with 96GB trying to get it to use as much memory as possible (I am the only user and I am running complex queries on large tables). [See my previous thread for details "Out of Memory and Configuration Problems (Big Computer)"].

There is no 64-bit Windows version of the postgresql binaries, so you probably won't be able to use more than 2 or 4 GB of all that memory...

There will be one once Postgres 9 is released: http://wiki.postgresql.org/wiki/64bit_Windows_port

> I have changed my postgres.conf file by changing the values of shared_buffers to 1024, work_mem = 1024 and effective_cache_size=2703601.

I'm pretty sure those values are in bytes, so these are awfully small values for a database server.

> Now my postgres service wont start from the windows Services dialog, however using pgAdmin I can start the service and connect to my database, run queries etc.

Sorry, can't help you there - I rarely use Windows.

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.

!DSPAM:737,4bffe51f10216640413027!