Re: Performance on 8CPU's and 32GB of RAM

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Trevor Talbot" <quension(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance on 8CPU's and 32GB of RAM
Date: 2007-09-05 19:29:25
Message-ID: dcc563d10709051229q28767cbtc61a5af11447faa5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 9/5/07, Trevor Talbot <quension(at)gmail(dot)com> wrote:
> On 9/5/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> > On 9/5/07, Carlo Stonebanks <stonec(dot)register(at)sympatico(dot)ca> wrote:
> > > > Right, additionally NTFS is really nothing to use on any serious disc
> > > > array.
> > >
> > > Do you mean that I will not see any big improvement if I upgrade the disk
> > > subsystem because the client is using NTFS (i.e. Windows)
> >
> > No, I think he's referring more to the lack of reliability of NTFS
> > compared to UFS / ZFS / JFS / XFS on unixen.
>
> Lack of reliability compared to _UFS_? Can you elaborate on this?

Not a lot. Back when I was an NT 4.0 sysadmin, I had many many
occasions where NTFS simply corrupted for no apparent reason. No
system crash, no obvious problems with the drive, and bang suddenly a
file goes corrupted. About that time I gave up on Windows and started
supporting Linux and Solaris. Neither is perfect, but I've never had
either of them just corrupt a file on good hardware for no reason.
Keep in mind, the machine that was corrupting files for no reason went
on to be our development / staging linux server, handling quite a
heavy load of developers on it, and never once had a corrupted file on
it.

With the newer journalling file systems on linux, solaris and BSD, you
get both good performance and very reliable behaviour. Maybe NTFS has
gotten better since then, but I don't personally know.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2007-09-05 19:36:43 Re: Performance on 8CPU's and 32GB of RAM
Previous Message Ron Mayer 2007-09-05 18:09:44 Re: Performance on 8CPU's and 32GB of RAM