Postgres Pro
Downloads
Home   >   mailing lists

Fragmentation of WAL files - Mailing list pgsql-performance

From Jim Nasby
Subject Fragmentation of WAL files
Date
Msg-id 3BD44C5D-E402-43EB-8FFD-1A4BC97AFD0C@decibel.org
Whole thread Raw
Responses Re: Fragmentation of WAL files  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-performance
Tree view 
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.

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.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: What`s wrong with JFS configuration?
Next
From: Jim Nasby
Date:
Subject: Re: seeking advise on char vs text or varchar in search table