From: Bill Moran <wmoran@collaborativefusion.com>
To: Jim Nasby <decibel@decibel.org>
Cc: Postgresql list Performance <pgsql-performance@postgresql.org>
Subject: Re: Fragmentation of WAL files
Date: Thu, 26 Apr 2007 08:00:50 -0400
Message-ID: <20070426080050.522ef7b5.wmoran@collaborativefusion.com> (raw)
In-Reply-To: <3BD44C5D-E402-43EB-8FFD-1A4BC97AFD0C@decibel.org>
References: <3BD44C5D-E402-43EB-8FFD-1A4BC97AFD0C@decibel.org>
In response to Jim Nasby <decibel@decibel.org>:
> I was recently running defrag on my windows/parallels VM and noticed
> a bunch of WAL files that defrag couldn't take care of, presumably
> because the database was running. What's disturbing to me is that
> these files all had ~2000 fragments. Now, this was an EnterpriseDB
> database which means the WAL files were 64MB instead of 16MB, but
> even having 500 fragments for a 16MB WAL file seems like it would
> definitely impact performance.
I don't know about that. I've seen marketing material that claims that
modern NTFS doesn't suffer performance problems from fragmentation. I've
never tested it myself, but my point is that you might want to do some
experiments -- you might find out that it doesn't make any difference.
If it does, you should be able to stop the DB, defragment the files, then
start the DB back up. Since WAL files are recycled, they shouldn't
fragment again -- unless I'm missing something.
If that works, it may indicate that (on Windows) a good method for installing
is to create all the necessary WAL files as empty files before launching
the DB.
> Can anyone else confirm this? I don't know if this is a windows-only
> issue, but I don't know of a way to check fragmentation in unix.
I can confirm that it's only a Windows problem. No UNIX filesystem
that I'm aware of suffers from fragmentation.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran@collaborativefusion.com
Phone: 412-422-3463x4023
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: wmoran@collaborativefusion.com, decibel@decibel.org
Subject: Re: Fragmentation of WAL files
In-Reply-To: <20070426080050.522ef7b5.wmoran@collaborativefusion.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