Re: Compression and on-disk sorting

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Compression and on-disk sorting
Дата
Msg-id 1147795019.69863.303.camel@home
обсуждение исходный текст
Ответ на Re: Compression and on-disk sorting  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Compression and on-disk sorting  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Tue, 2006-05-16 at 11:53 -0400, Andrew Dunstan wrote:
> 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 ...

Disk storage is cheap. Disk bandwidth or throughput is very expensive.
-- 



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Compression and on-disk sorting
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Compression and on-disk sorting