Re: [HACKERS] sorting big tables :(
От | Oleg Broytmann |
---|---|
Тема | Re: [HACKERS] sorting big tables :( |
Дата | |
Msg-id | Pine.LNX.3.96.SK.980521101037.16715C-100000@torus.comus.ru обсуждение исходный текст |
Ответ на | Re: [HACKERS] sorting big tables :( (The Hermit Hacker <scrappy@hub.org>) |
Ответы |
Re: [HACKERS] sorting big tables :(
|
Список | 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 по дате отправления: