Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id E19491337A5D for ; Tue, 12 Apr 2011 12:27:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 93891-03 for ; Tue, 12 Apr 2011 15:27:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from ns3b.twi.com.br (ns3b.twi.com.br [201.87.225.54]) by mail.postgresql.org (Postfix) with ESMTP id 5DE8E13364DE for ; Tue, 12 Apr 2011 12:27:29 -0300 (ADT) Received: (qmail 51762 invoked from network); 12 Apr 2011 12:27:26 -0300 Received: from unknown (HELO gibon) (gibon@comexsystem.com.br@[187.116.48.235]) (envelope-sender ) by ns3b.twi.com.br (qmail-ldap-1.03) with SMTP for ; 12 Apr 2011 12:27:26 -0300 Message-ID: <002401cbf925$be99ae80$eb3074bb@gibon> Reply-To: =?ISO-8859-15?Q?F=E1bio_Gibon_-_Comex_System?= From: =?ISO-8859-15?Q?F=E1bio_Gibon_-_Comex_System?= To: "Kevin Grittner" , "PostgreSQL - mailing list" References: <003201cbf90a$470b6770$eb3074bb@gibon> <4DA4190A020000250003C6D7@gw.wicourts.gov> Subject: Re: Shared_buffer limited by SO Date: Tue, 12 Apr 2011 12:24:19 -0300 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="ISO-8859-15"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.239 tagged_above=-10 required=5 tests=BAYES_50=0.8, STOX_REPLY_TYPE=0.439 X-Spam-Level: * X-Archive-Number: 201104/109 X-Sequence-Number: 37290 > Fábio Gibon - Comex System wrote: > >> are there how define high more than 512Mb to shared_buffer on >> windows? > > What happens when you set it higher than that? Database don't start e show this message (português): 2011-04-12 12:10:22 BRT FATAL: não pôde criar segmento de memória compartilhada: 8 (can't create a shared memory segment) 2011-04-12 12:10:22 BRT DETALHE: Falhou ao executar chamada de sistema MapViewOfFileEx. (fail on run system call mapviewoffileex, or like this...) > > Also, it would be useful to know the version of PostgreSQL, the > version of Windows, the amount of RAM on the system, etc. Windows Server 2003 - Standard Edition - SP1 - 32bits PostgreSQL 8.4.3 RAM 4GB This error ocurred when I try set shared_buffers to 1GB, with 768MB work fine. > > -Kevin >