I am running postgresql 9.2 on a 32-bit machine running windows xp with 4 gb of memory and I am getting out of memory errors. I suspect it has something to do with these two parameters I have changed related to memory:
shared_buffers = 1024 MB maintenance_work_mem = 1024 MB
Before changing these parameters, I was not getting out-of-memory errors. Is this too much for a 32-bit machine?