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

From Bort, Paul
Subject Re: Compression and on-disk sorting
Date
Msg-id DB106B1B5B8F734B8FF3E155A3A556C202D4FA85@clemail1.tmwsystems.com
Whole thread Raw
In response to Compression and on-disk sorting  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Compression and on-disk sorting
List pgsql-hackers
>
> 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.



pgsql-hackers by date:

Previous
From: winlinchu
Date:
Subject: Help!!!!
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Creating a Pseudocolumn