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.