Horton

Re: PostgreSQL win32 fragmentation issue

Thomas H. <me@alternize.com>

View thread View on postgr.es
From: "Thomas H." <me@alternize.com>
To: "Magnus Hagander" <mha@sollentuna.net>, "Matthew T. O'Connor" <matthew@zeut.net>, "Martijn van Oosterhout" <kleptog@svana.org>
Cc: "Joshua D. Drake" <jd@commandprompt.com>, "PostgreSQL-development" <pgsql-hackers@postgresql.org>
Date: 2006-12-02T23:07:19Z
Lists: pgsql-hackers 
>> in our win32/ntfs environment, only 6 pgsql data-files are
>> fragmented. but they are heavily fragmented. fragmentiation
>> ranges from 1369 fragments for a 14mb file to 4548 fragments
>> for a 628mb one... the database is only 1 week old.

> Which relations do these files represent?

all 6 of them tables are tables. makes sense as reindex would recreate the 
index file more or less at once and thus without much fragmentation...

- thomas