Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas H.
Subject Re: PostgreSQL win32 fragmentation issue
Date
Msg-id 0f5b01c71640$a65ab930$0201a8c0@iwing
Whole thread Raw
In response to PostgreSQL win32 fragmentation issue  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
Tree view 
> (I should have thought a single file DB would be MORE liable to
> fragmentation, BTW).

AFAIK what mssql does against fragmentation is: it preallocates its 
tablespace in chunks of several mb/gb and then starts filling the free 
allocated space until it has to reallocate more. the fragmentation for such 
a single file (actually in most times 2 files for mssql) is practically 
ignorable.

- thomas

pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: PostgreSQL win32 fragmentation issue
Next
From: "Simon Riggs"
Date:
Subject: Re: PostgreSQL win32 fragmentation issue