PostgreSQL win32 fragmentation issue
Joshua D. Drake <jd@commandprompt.com>
From: "Joshua D. Drake" <jd@commandprompt.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2006-12-02T06:58:44Z
Lists: pgsql-hackers
Hello, I ran a simple test... I ran defrag on my drives. Then I initialized pgbench with a -s 1000. 11% fragmentation. I dropped the bench database, and my fragmentation is 1%. I know this isn't *our* fault :) but I am curious if there is anything we can do about the way postgresql writes files to help limit fragmentation. Essentially, this makes win32 impossible in a 24x7 environment (jokes aside about Win32 in general) because we *have* to defrag on Windows and Windows won't defrag open files (thus anything PostgreSQL is using). Sincerely, Joshua D. Drake