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 :(  (The Hermit Hacker <scrappy@hub.org>)
Список 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 по дате отправления:

Предыдущее
От: "Stupor Genius"
Дата:
Сообщение: RE: [HACKERS] sorting big tables :(
Следующее
От: Peter Mount
Дата:
Сообщение: RE: [HACKERS] Kerberos 5 breakage.