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

From Tom Lane
Subject Re: PostgreSQL win32 fragmentation issue
Date
Msg-id 12796.1165120575@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL win32 fragmentation issue  (Mark Kirkwood <markir@paradise.net.nz>)
Responses Re: PostgreSQL win32 fragmentation issue  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Re: PostgreSQL win32 fragmentation issue  ("Magnus Hagander" <mha@sollentuna.net>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] GUC description cleanup
Next
From: "Gurjeet Singh"
Date:
Subject: Re: PostgreSQL win32 fragmentation issue