Re: [GENERAL] Config Changes Broke Postgres Service (Windows)

2010-05-28 Thread Alban Hertroys
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 deta

Re: [GENERAL] Config Changes Broke Postgres Service (Windows)

2010-05-28 Thread Tom Wilcox
Hi Stephen, Thanks for the response. Unfortunately, we are somewhat tied to a Windows platform and I would expect us to sooner switch to SQL Server rather than move to Linux/Unix/BSD.. Although, (in complete contrast to what I just said), I am toying with the idea of the dual boot or virtuali

Re: [GENERAL] Config Changes Broke Postgres Service (Windows)

2010-05-28 Thread Stephen Frost
* Tom Wilcox (hungry...@googlemail.com) wrote: > Can anyone tell me what might be going on and how I can fix it so that > postgres uses as much memory and processing power as poss... in a stable > manner? I realize this probably isn't the answer you're looking for, and hopefully someone can come u

[GENERAL] Config Changes Broke Postgres Service (Windows)

2010-05-28 Thread Tom Wilcox
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)