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
memoryas 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
ofall 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
andconnect 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!