Re: [HACKERS] sorting big tables :(

Oleg Broytmann <phd@comus.ru>

From: Oleg Broytmann <phd@comus.ru>
To: The Hermit Hacker <scrappy@hub.org>
Cc: hackers@postgreSQL.org
Date: 1998-05-21T06:12:50Z
Lists: 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.