| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Postgresql list Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Fragmentation of WAL files |
| Date: | 2007-04-25 17:26:07 |
| Message-ID: | 3BD44C5D-E402-43EB-8FFD-1A4BC97AFD0C@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2007-04-25 17:30:41 | Re: seeking advise on char vs text or varchar in search table |
| Previous Message | Chris Browne | 2007-04-25 14:46:28 | Re: What`s wrong with JFS configuration? |