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

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

Previous
From: Andrew Dunstan
Date:
Subject: Re: Compression and on-disk sorting
Next
From: Andrew Dunstan
Date:
Subject: Re: Compression and on-disk sorting