Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 736A82E0037 for ; Sat, 24 Nov 2007 04:53:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 95997-09 for ; Sat, 24 Nov 2007 04:53:29 -0400 (AST) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id 55CED2E0033 for ; Sat, 24 Nov 2007 04:53:29 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id f5so50707nfh for ; Sat, 24 Nov 2007 00:53:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; bh=bYF7X8lu4AKEw05F4OB4VhIAT8ahbwlAWwM6lk75V4k=; b=jomdqqgWVPg+i+CJ2MIO/gTeaSNhXnevEXK9pGAGrOUzD40bG3F4cu7pK42b0ydil6BMvEaUYkolMVTqBl+fpk2tWmM1WynLGc+fivM52vshDgem2br9WUDy9D5V0nXcfpv7SeyUTNgsE0pWYiw4Hq5GuRsc0AmW3HlWvdrYNzA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=PQXbYr3/poISXs5Y6a0OLB/eFy7wKRtzj+5qHiQcJdKD+aZ61g/tVSV6NJc/GyrC10spMy+d1/tDWgP06gr9+fcSOkBKCNswPY2fd+XJv/b6oCZJZ1gl90uOpzMsvE+zeRpMpfue4SHYKMTxxrhWZnokRa66qkQ/K3P4AA5h59A= Received: by 10.82.150.20 with SMTP id x20mr619617bud.1195894407268; Sat, 24 Nov 2007 00:53:27 -0800 (PST) Received: from ?192.168.1.33? ( [82.27.246.36]) by mx.google.com with ESMTPS id f6sm5179361nfh.2007.11.24.00.53.25 (version=SSLv3 cipher=RC4-MD5); Sat, 24 Nov 2007 00:53:26 -0800 (PST) Message-ID: <4747E684.2000509@enterprisedb.com> Date: Sat, 24 Nov 2007 08:53:24 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.14pre (X11/20071020) MIME-Version: 1.0 To: claudia.amorim@pcinformatica.com.br CC: pgsql-performance@postgresql.org, claudiacomput@hotmail.com Subject: Re: Problems with PostGreSQL and Windows 2003 References: <50326.189.5.149.224.1195860047.squirrel@smart> In-Reply-To: <50326.189.5.149.224.1195860047.squirrel@smart> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/283 X-Sequence-Number: 27698 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