Horton

Re: PostgreSQL win32 fragmentation issue

Thomas H. <me@alternize.com>

View thread View on postgr.es
From: "Thomas H." <me@alternize.com>
To: "Mark Kirkwood" <markir@paradise.net.nz>
Cc: "Andrew Dunstan" <andrew@dunslane.net>, "Joshua D. Drake" <jd@commandprompt.com>, "Martijn van Oosterhout" <kleptog@svana.org>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2006-12-02T23:58:46Z
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