Re: PostgreSQL win32 fragmentation issue

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mark Kirkwood <markir@paradise.net.nz>
Cc: Andrew Dunstan <andrew@dunslane.net>, "Joshua D. Drake" <jd@commandprompt.com>, Martijn van Oosterhout <kleptog@svana.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2006-12-03T04:36:15Z
Lists: pgsql-hackers
Mark Kirkwood <markir@paradise.net.nz> writes:
> A related point comes to mind, consider the single "tablespace" file for 
> example: It may have no fragmentation from a *file* perspective, but 
> supposing you have several busy relations being inserted or updated then 
> pages (or groups of pages) for these could be "fragmented" throughout 
> the tablespace file.

+1 ... what was said upthread sounds to me like those other databases
are just hiding the fragmentation issue within their
huge-files-you-can't-see-into.  I would very much like to see some proof
of performance problems before we worry about this.

			regards, tom lane