Skip site navigation (1) Skip section navigation (2)

Re: Fragmentation of WAL files

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Postgresql list Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Fragmentation of WAL files
Date: 2007-04-27 04:50:55
Message-ID: Pine.GSO.4.64.0704270019060.8684@westnet.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, 26 Apr 2007, Bill Moran wrote:

> I've seen marketing material that claims that modern NTFS doesn't suffer 
> performance problems from fragmentation.

You're only reading half of the marketing material then.  For a balanced 
picture, read the stuff generated by the companies that sell defragmenting 
tools.  A good one to start with is 
http://files.diskeeper.com/pdf/HowFileFragmentationOccursonWindowsXP.pdf

Going back to the Jim's original question, they suggest a Microsoft paper 
that talks about how the defrag report can be misleading in respect to 
open files.  See http://support.microsoft.com/kb/228198

Also, some of the most interesting details they gloss over are specific to 
which version of Windows you're using; the reference guide to the subject 
of how NTFS decides how much space to pre-allocate at a time is available 
at http://support.microsoft.com/kb/841551 (ZIP file wrapped into EXE, 
yuck!)

If you compare them, you can see that the approach they're using in NTFS 
has evolved to become more like that used by a good UNIX filesystem over 
time.  I think your typical UNIX still has a healthy lead in this area, 
but the difference isn't as big as it used to be.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

pgsql-performance by date

Next:From: Arjen van der MeijdenDate: 2007-04-27 06:07:38
Subject: Re: index structure for 114-dimension vector
Previous:From: Oleg BartunovDate: 2007-04-27 04:46:21
Subject: Re: Simple query, 10 million records...MySQL ten times faster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group