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