Re: [HACKERS] sorting big tables :(

Поиск
Список
Период
Сортировка
От Tom
Тема Re: [HACKERS] sorting big tables :(
Дата
Msg-id Pine.BSF.3.95q.980520094022.12309C-100000@misery.sdf.com
обсуждение исходный текст
Ответ на Re: [HACKERS] sorting big tables :(  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: [HACKERS] sorting big tables :(  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
On Wed, 20 May 1998, The Hermit Hacker wrote:

>     One of the things that the Unix FS does is auto-defragmenting, at
> least the UFS one does.  Whenever the system is idle (from my
> understanding), the kernel uses that time to clean up the file systems, to
> reduce the file system fragmentation.

  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).

Tom


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Re: [DOCS] Re: FE/BE protocol revision patch
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] sorting big tables :(