Re: PostgreSQL win32 fragmentation issue - Mailing list pgsql-hackers

From Thomas H.
Subject Re: PostgreSQL win32 fragmentation issue
Date
Msg-id 102c01c71666$9f347940$0201a8c0@iwing
Whole thread Raw
In response to Re: PostgreSQL win32 fragmentation issue  ("Magnus Hagander" <mha@sollentuna.net>)
List 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 




pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: implementar un metodo de indexacion
Next
From: Mark Kirkwood
Date:
Subject: Re: PostgreSQL win32 fragmentation issue