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
|
Список | 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 по дате отправления: