From: Heikki Linnakangas <heikki@enterprisedb.com>
To: claudia.amorim@pcinformatica.com.br
Cc: pgsql-performance@postgresql.org
Cc: claudiacomput@hotmail.com
Subject: Re: Problems with PostGreSQL and Windows 2003
Date: Sat, 24 Nov 2007 08:53:24 +0000
Message-ID: <4747E684.2000509@enterprisedb.com> (raw)
In-Reply-To: <50326.189.5.149.224.1195860047.squirrel@smart>
References: <50326.189.5.149.224.1195860047.squirrel@smart>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: heikki@enterprisedb.com, claudia.amorim@pcinformatica.com.br, claudiacomput@hotmail.com
Subject: Re: Problems with PostGreSQL and Windows 2003
In-Reply-To: <4747E684.2000509@enterprisedb.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox