Re: Compression and on-disk sorting

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Compression and on-disk sorting
Дата
Msg-id 4469F586.3050706@dunslane.net
обсуждение исходный текст
Ответ на Re: Compression and on-disk sorting  ("Bort, Paul" <pbort@tmwsystems.com>)
Ответы Re: Compression and on-disk sorting  (Rod Taylor <pg@rbt.ca>)
Список pgsql-hackers
Bort, Paul wrote:
>> Compressed-filesystem extension (like e2compr, and I think either
>> Fat or NTFS) can do that.
>>
>>     
>
> Windows (NT/2000/XP) can compress individual directories and files under
> NTFS; new files in a compressed directory are compressed by default.
>
> So if the 'spill-to-disk' all happened in its own specific directory, it
> would be trivial to mark that directory for compression. 
>
> I don't know enough Linux/Unix to know if it has similar capabilities.
>
>
>   

Or would want to ...

I habitually turn off all compression on my Windows boxes, because it's 
a performance hit in my experience. Disk is cheap ...

cheers

andrew


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

Предыдущее
От: Cristiano Duarte
Дата:
Сообщение: Re: [BUGS] BUG #2429: Explain does not report object's schema
Следующее
От: Rod Taylor
Дата:
Сообщение: Re: Compression and on-disk sorting