| From: | "Bort, Paul" <pbort(at)tmwsystems(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Compression and on-disk sorting |
| Date: | 2006-05-16 13:09:51 |
| Message-ID: | DB106B1B5B8F734B8FF3E155A3A556C202D4FA85@clemail1.tmwsystems.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
>
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2006-05-16 13:13:24 | Re: Wrong plan for simple join with index on FK |
| Previous Message | Zeugswetter Andreas DCP SD | 2006-05-16 12:35:43 | Re: Wrong plan for simple join with index on FK |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-05-16 13:43:42 | Re: .pgpass file and unix domain sockets |
| Previous Message | Joachim Wieland | 2006-05-16 12:25:55 | .pgpass file and unix domain sockets |