Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 2E6B99FB5F6
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri,  7 Sep 2007 14:34:38 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 79535-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri,  7 Sep 2007 14:34:24 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.185])
	by postgresql.org (Postfix) with ESMTP id E93599FB516
	for <pgsql-performance@postgresql.org>;
	Fri,  7 Sep 2007 14:32:55 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id 30so457536nfu
	for <pgsql-performance@postgresql.org>;
	Fri, 07 Sep 2007 10:32:54 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=xyfcI+SQziGXyq8+xk6BOFgGn+ja/sf5m8B6BfMFdwo=;
	b=gkJ1lLOlmug5K70PjBZgsUi6aT3a3U7uJpGUS927dTSbctBNEPeN62c4Frc99D39rYSA49YeaQu9ZgzIcK7xF8KyN3QhRObm8j9ZwDvNer6naZB4kzhaHkcnhGre8MVxx1GIV2/BAD0OAuR+ygkbAfZHEZGfy+A1Z3ire2rqhCA=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=frRbaeLqzCDmJyCEvzlIx3Zq5RqVPobPe8CJWj1EWjaWeU/g6hTVUymzFC9J7ZnT5d5JGcg8wcm9Wln7e4YhSEhvkPnoudLZfEeUc7NGXTdNUTH1bwMOGiu61szhEs6NADbw4onq0JbI/HgBN2QbXa1rKRP9EtVtL2cWV7omrME=
Received: by 10.78.142.14 with SMTP id p14mr868035hud.1189186374070;
	Fri, 07 Sep 2007 10:32:54 -0700 (PDT)
Received: by 10.78.190.2 with HTTP; Fri, 7 Sep 2007 10:32:53 -0700 (PDT)
Message-ID: <7be3f35d0709071032n4615b7d9i337fbc314679b9a3@mail.gmail.com>
Date: Fri, 7 Sep 2007 19:32:53 +0200
From: "Harald Armin Massa" <haraldarminmassa@gmail.com>
To: "Scott Marlowe" <scott.marlowe@gmail.com>
Subject: Re: Performance on 8CPU's and 32GB of RAM
Cc: pgsql-performance@postgresql.org
In-Reply-To: <dcc563d10709070916n6a0a0a1cra17a244648b67be7@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_905_33247111.1189186373986"
References: <fbkn5d$cfq$1@news.hub.org>
 <20070904230639.GA23731@alvh.no-ip.org>
	<dcc563d10709041615s305ae98bm92dee61ab199b7c4@mail.gmail.com>
	<46DE66CF.9000903@theendofthetunnel.de> <fbmhjt$d51$1@news.hub.org>
	<dcc563d10709050845k135d3c2erbe5b44933e898aa@mail.gmail.com>
	<90bce5730709051016j5291827dx525d6b8fe4960fbd@mail.gmail.com>
	<dcc563d10709051236o60f852cdne392937704830200@mail.gmail.com>
	<82ir6mnb3s.fsf@mid.bfk.de>
	<dcc563d10709070916n6a0a0a1cra17a244648b67be7@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200709/130
X-Sequence-Number: 26675

------=_Part_905_33247111.1189186373986
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Scott,

Well, there've been a lot of issues with anti-virus and postgresql not
> getting along.  I wonder if pgsql takes out a stronger lock, and when
> it can't get it then the failure happens.  Not familiar enough with
> windows to do more than speculate.


without touching the file-concurrency issues caused by virus scanners:

a LOT of the Postgres <-> VirusScanner problems on Windows were caused
during the "postgres spawns a new process and communicates with that proces=
s
via ipstack"

Many Virus Scanners seam to have dealt with the TCP/IP stack in a not
compatible manner...

Harald

--=20
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Stra=DFe 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

------=_Part_905_33247111.1189186373986
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Scott,<br><br><div><blockquote class=3D"gmail_quote" style=3D"border-left: =
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;=
">Well, there&#39;ve been a lot of issues with anti-virus and postgresql no=
t
<br>getting along.&nbsp;&nbsp;I wonder if pgsql takes out a stronger lock, =
and when<br>it can&#39;t get it then the failure happens.&nbsp;&nbsp;Not fa=
miliar enough with<br>windows to do more than speculate.</blockquote><br>wi=
thout touching the file-concurrency issues caused by virus scanners:
<br><br>a LOT of the Postgres &lt;-&gt; VirusScanner problems on Windows we=
re caused during the &quot;postgres spawns a new process and communicates w=
ith that process via ipstack&quot; <br><br>Many Virus Scanners seam to have=
 dealt with the TCP/IP stack in a not compatible manner...
<br><br></div>Harald<br><br>-- <br>GHUM Harald Massa<br>persuadere et progr=
ammare<br>Harald Armin Massa<br>Spielberger Stra=DFe 49<br>70435 Stuttgart<=
br>0173/9409607<br>fx 01212-5-13695179 <br>-<br>EuroPython 2008 will take p=
lace in Vilnius, Lithuania - Stay tuned!

------=_Part_905_33247111.1189186373986--