Re: [HACKERS] sorting big tables :(

Поиск
Список
Период
Сортировка
От Eivind Eklund
Тема Re: [HACKERS] sorting big tables :(
Дата
Msg-id 19980520224430.04725@follo.net
обсуждение исходный текст
Ответ на Re: [HACKERS] sorting big tables :(  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
On Wed, May 20, 1998 at 01:17:34PM -0400, The Hermit Hacker wrote:
> On Wed, 20 May 1998, Tom 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.  What is done is (quite correctly) fragmentation avoidance.  Big
files are even sometimes fragmented on purpose, to allow small files
that are written later to avoid being fragmented.

Eivind.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Matthew N. Dodd"
Дата:
Сообщение: Re: [HACKERS] Kerberos 5 breakage.
Следующее
От: Hamish.N.MARSON@British-Airways.com
Дата:
Сообщение: Bug in postgresql-6.3.2