Re: Compression and on-disk sorting

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DCP SD
Тема Re: Compression and on-disk sorting
Дата
Msg-id E1539E0ED7043848906A8FF995BDA57901054657@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Compression and on-disk sorting  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: Compression and on-disk sorting
Список pgsql-hackers
> 1) Use n sort areas for n tapes making everything purely sequential
access.

Some time ago testing I did has shown, that iff the IO block size is
large enough
(256k) it does not really matter that much if the blocks are at random
locations.
I think that is still true for current model disks.

So unless we parallelize, it is imho sufficient to see to it that we
write
(and read) large enough blocks with single calls. This also has no
problem in
highly concurrent scenarios, where you do not have enough spindles.

Andreas


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

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: PL/pgSQL 'i = i + 1' Syntax
Следующее
От: Dhanaraj M
Дата:
Сообщение: Re: Clarification required