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

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

Previous
From: Rod Taylor
Date:
Subject: Re: Compression and on-disk sorting
Next
From: Andrew Dunstan
Date:
Subject: Re: [PATCHES] .pgpass file and unix domain sockets