claudia.amorim@pcinformatica.com.br wrote:
> I'm having serious peformance problems with PostGreSQL and Windows Server 2003
> Enterprise Edition. The PostgreSQL Server don't starts if I set the shared
> buffers high than
> 1GB. All my programs can use only 3 GB of RAM and I have 8GB of RAM.
> When I try to execute a query in a table about 4 milion registers, my
> application crashes with an error memory message.
What error message do you get if setting shared_buffers higher than 1GB?
Exactly what error message do you get when the application crashes?
> work_mem =512MB # min 64kB
That's way too high for most applications. In a complex query, each sort
or hash node can will use up work_mem amount of memory. That means that
if you have a very complex query with several such nodes, it will run
out of memory. Try something like 16MB.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com