From: Scott Marlowe <scott.marlowe@gmail.com>
To: James Mansion <james@mansionfamily.plus.com>
Cc: Trevor Talbot <quension@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance on 8CPU's and 32GB of RAM
Date: Thu, 6 Sep 2007 15:59:34 -0500
Message-ID: <dcc563d10709061359y28b4098es786599bc49ae3c33@mail.gmail.com> (raw)
In-Reply-To: <46E0637F.2040800@mansionfamily.plus.com>
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>
<46E0637F.2040800@mansionfamily.plus.com>
On 9/6/07, James Mansion <james@mansionfamily.plus.com> wrote:
> Scott Marlowe wrote:
> > And there's the issue that with windows / NTFS that when one process
> > opens a file for read, it locks it for all other users. This means
> > that things like virus scanners can cause odd, unpredictable failures
> > of your database.
> >
> >
> Can you provide some justification for this?
Seeing as I didn't write Windows or any of the plethora of anti-virus
software, no I really can't. It's unforgivable behaviour.
Can I provide evidence that it happens? Just read the archives of
this list for the evidence. I've seen it often enough to know that
most anti-virus software seems to open files in exclusive mode and
cause problems for postgresql, among other apps.
> Why do you think that UNIX systems are better at handling large shared
> buffers than Wndows?
Because we've seen lots of problems with large shared buffers on windows here.
Now, maybe for a windows specific app it's all fine and dandy. but
for the way pgsql works, windows and large shared buffers don't seem
to get along.
I'm done. Use windows all you want. I'll stick to unix. It seems to
just work for pgsql.
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: scott.marlowe@gmail.com, james@mansionfamily.plus.com, quension@gmail.com
Subject: Re: Performance on 8CPU's and 32GB of RAM
In-Reply-To: <dcc563d10709061359y28b4098es786599bc49ae3c33@mail.gmail.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