I have a production database that is running on Win32 NTFS with PostgreSQL 8.2.1. The drive that the data is stored on is dedicated to PostgreSQL data files (transaction log stored on a separate disk) The data partition is currently 44% fragmented, which I believe is resulting in performance degradation. I don't have any benchmarks though.
"Joshua D. Drake" wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq