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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
