Re: Compression and on-disk sorting

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Compression and on-disk sorting
Дата
Msg-id 4469FD7E.2070805@dunslane.net
обсуждение исходный текст
Ответ на Re: Compression and on-disk sorting  (Rod Taylor <pg@rbt.ca>)
Ответы Re: Compression and on-disk sorting
Список pgsql-hackers
Rod Taylor wrote:
>> I habitually turn off all compression on my Windows boxes, because it's 
>> a performance hit in my experience. Disk is cheap ...
>>     
>
> Disk storage is cheap. Disk bandwidth or throughput is very expensive.
>   

Sure, but in my experience using Windows File System compression is not 
a win here. Presumably if it were an unqualified win they would have it 
turned on everywhere. The fact that there's an option is a good 
indication that it isn't in many cases. It is most commonly used for 
files like executables that are in effect read-only - but that doesn't 
help us.

cheers

andrew



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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Compression and on-disk sorting
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [PATCHES] .pgpass file and unix domain sockets