Re: [HACKERS] sorting big tables :( - Mailing list pgsql-hackers

From Oleg Broytmann
Subject Re: [HACKERS] sorting big tables :(
Date
Msg-id Pine.LNX.3.96.SK.980521101037.16715C-100000@torus.comus.ru
Whole thread Raw
In response to Re: [HACKERS] sorting big tables :(  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [HACKERS] sorting big tables :(
List pgsql-hackers
Hello!

On Wed, 20 May 1998, The Hermit Hacker wrote:
> >   No, that doesn't happen.  The only way to eliminate fragmentation is a
> > dump/newfs/restore cycle.  UFS does do fragmentation avoidance (which is
> > reason UFS filesystems have a 10% reserve).
>
>     Okay, then we have two different understandings of this.  My
> understanding was that the 10% reserve gave the OS a 'temp area' in which
> to move blocks to/from so that it could defrag on the fly...

   No, you are wrong. This 10% is temp area reserved for emergent
situations - when root bring system down to single-user and do system
maintainance.

Oleg.
----
  Oleg Broytmann     http://members.tripod.com/~phd2/     phd2@earthling.net
           Programmers don't die, they just GOSUB without RETURN.


pgsql-hackers by date:

Previous
From: "Stupor Genius"
Date:
Subject: RE: [HACKERS] sorting big tables :(
Next
From: Peter Mount
Date:
Subject: RE: [HACKERS] Kerberos 5 breakage.