Re: Compression and on-disk sorting - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Compression and on-disk sorting
Date
Msg-id 4469F586.3050706@dunslane.net
Whole thread Raw
In response to Re: Compression and on-disk sorting  ("Bort, Paul" <pbort@tmwsystems.com>)
Responses Re: Compression and on-disk sorting  (Rod Taylor <pg@rbt.ca>)
List 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 by date:

Previous
From: Cristiano Duarte
Date:
Subject: Re: [BUGS] BUG #2429: Explain does not report object's schema
Next
From: Rod Taylor
Date:
Subject: Re: Compression and on-disk sorting