| From: | "Thomas H(dot)" <me(at)alternize(dot)com> |
|---|---|
| To: | "Magnus Hagander" <mha(at)sollentuna(dot)net>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, "Martijn van Oosterhout" <kleptog(at)svana(dot)org> |
| Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL win32 fragmentation issue |
| Date: | 2006-12-02 23:07:19 |
| Message-ID: | 102c01c71666$9f347940$0201a8c0@iwing |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2006-12-02 23:09:18 | Re: PostgreSQL win32 fragmentation issue |
| Previous Message | Alvaro Herrera | 2006-12-02 22:53:27 | Re: implementar un metodo de indexacion |