| From: | "Thomas H(dot)" <me(at)alternize(dot)com> |
|---|---|
| To: | "Mark Kirkwood" <markir(at)paradise(dot)net(dot)nz> |
| Cc: | "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL win32 fragmentation issue |
| Date: | 2006-12-02 23:58:46 |
| Message-ID: | 10e701c7166d$cef5f3a0$0201a8c0@iwing |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
by the way... at least on windows 2003 file fragmentation is *not* really an
issue. thanks to the vssvc (shadowcopy) even files that are in use are being
defragmented. as far as i know, vssvc is also there in xp, but i can't
verify.
running a quick defrag on the db data partition defragmented all the
beforementioned heavily fragmented relation files without any problems,
eventhough the tables are actually being updated and in use while
defragmenting.
a regular defrag will be sufficient to keep the performance hit low - if
there is any noticable in first place, that is.
- thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shane Ambler | 2006-12-03 03:03:59 | Re: PostgreSQL win32 fragmentation issue |
| Previous Message | Mark Kirkwood | 2006-12-02 23:31:37 | Re: PostgreSQL win32 fragmentation issue |