From gibon@comexsystem.com.br Tue Apr  12 12:30:22 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 89F3B1337A5D
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 12 Apr 2011 09:30:22 -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 76980-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 12 Apr 2011 12:30:05 +0000 (UTC)
X-Greylist: delayed 00:19:10.461732 by SQLgrey-1.7.6
Received: from ns3a.twi.com.br (ns3a.twi.com.br [201.87.225.53])
	by mail.postgresql.org (Postfix) with ESMTP id 425A51337999
	for <pgsql-admin@postgresql.org>; Tue, 12 Apr 2011 09:30:04 -0300 (ADT)
Received: (qmail 43452 invoked from network); 12 Apr 2011 09:10:49 -0300
Received: from unknown (HELO gibon)
 (gibon@comexsystem.com.br@[187.116.48.235])
	(envelope-sender <gibon@comexsystem.com.br>)
	by ns3a.twi.com.br (qmail-ldap-1.03) with SMTP
	for <pgsql-admin@postgresql.org>; 12 Apr 2011 09:10:49 -0300
Message-ID: <003201cbf90a$470b6770$eb3074bb@gibon>
Reply-To: =?Windows-1252?Q?F=E1bio_Gibon_-_Comex_System?=
	<gibon@comexsystem.com.br>
From: =?Windows-1252?Q?F=E1bio_Gibon_-_Comex_System?=
	<gibon@comexsystem.com.br>
To: "PostgreSQL - mailing list" <pgsql-admin@postgresql.org>
Subject: Shared_buffer limited by SO
Date: Tue, 12 Apr 2011 09:07:29 -0300
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_002C_01CBF8F1.0D032DB0"
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=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201104/99
X-Sequence-Number: 37280

This is a multi-part message in MIME format.

------=_NextPart_000_002C_01CBF8F1.0D032DB0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi,
    are there how define high more than 512Mb to shared_buffer on =
windows?

thanks
=20
F=E1bio Henrique Gibon
------=_NextPart_000_002C_01CBF8F1.0D032DB0
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252"><BASE=20
href=3D"file://C:\Arquivos de programas\Arquivos comuns\Microsoft =
Shared\Papel de carta\">
<STYLE></STYLE>

<META content=3D"MSHTML 6.00.2900.3132" name=3DGENERATOR></HEAD>
<BODY background=3D"">
<DIV>Hi,</DIV>
<DIV>&nbsp;&nbsp;&nbsp; are there how define high more than 512Mb to=20
shared_buffer on windows?</DIV>
<DIV>&nbsp;</DIV>
<DIV>thanks</DIV>
<DIV>&nbsp;<BR>F=E1bio Henrique Gibon</DIV></BODY></HTML>

------=_NextPart_000_002C_01CBF8F1.0D032DB0--




From Kevin.Grittner@wicourts.gov Tue Apr  12 14:19:16 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 8A3B71337BB4
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 12 Apr 2011 11:19:16 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 87503-01 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 12 Apr 2011 14:19:09 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by mail.postgresql.org (Postfix) with ESMTP id 553FE1337B83
	for <pgsql-admin@postgresql.org>; Tue, 12 Apr 2011 11:19:09 -0300 (ADT)
Received: from Courts-MTA by gw.wicourts.gov
	with Novell_GroupWise; Tue, 12 Apr 2011 09:19:09 -0500
Message-Id: <4DA4190A020000250003C6D7@gw.wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 8.0.1 
Date: Tue, 12 Apr 2011 09:19:06 -0500
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "=?ISO-8859-15?Q?F=E1bio=20Gibon=20-=20Comex=20System?="
	<gibon@comexsystem.com.br>,
	"PostgreSQL - mailing list" <pgsql-admin@postgresql.org>
Subject: Re: Shared_buffer limited by SO
References: <003201cbf90a$470b6770$eb3074bb@gibon>
In-Reply-To: <003201cbf90a$470b6770$eb3074bb@gibon>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5
	tests=BAYES_20=-0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201104/105
X-Sequence-Number: 37286

Fábio Gibon - Comex System<gibon@comexsystem.com.br> wrote:
 
> are there how define high more than 512Mb to shared_buffer on
> windows?
 
What happens when you set it higher than that?
 
Also, it would be useful to know the version of PostgreSQL, the
version of Windows, the amount of RAM on the system, etc.
 
-Kevin



From gibon@comexsystem.com.br Tue Apr  12 15:27:56 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id E19491337A5D
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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 <gibon@comexsystem.com.br>)
	by ns3b.twi.com.br (qmail-ldap-1.03) with SMTP
	for <Kevin.Grittner@wicourts.gov>; 12 Apr 2011 12:27:26 -0300
Message-ID: <002401cbf925$be99ae80$eb3074bb@gibon>
Reply-To: =?ISO-8859-15?Q?F=E1bio_Gibon_-_Comex_System?=
	<gibon@comexsystem.com.br>
From: =?ISO-8859-15?Q?F=E1bio_Gibon_-_Comex_System?=
 <gibon@comexsystem.com.br>
To: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>,
	"PostgreSQL - mailing list" <pgsql-admin@postgresql.org>
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<gibon@comexsystem.com.br> 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
>