Re: [GENERAL] forcing compression of text field

2006-12-13 Thread Bruce Momjian
Tom Lane wrote: Scott Marlowe [EMAIL PROTECTED] writes: On Mon, 2006-12-11 at 10:18, Jonathan Ellis wrote: I have a table of log messages. They are mostly in the 100-200 character length, which apparently isn't large enough for PG to want to compress it (length == octet_length). I

Re: [GENERAL] forcing compression of text field

2006-12-12 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/11/06 10:18, Jonathan Ellis wrote: I have a table of log messages. They are mostly in the 100-200 character length, which apparently isn't large enough for PG to want to compress it (length == octet_length). I really need to save disk

[GENERAL] forcing compression of text field

2006-12-11 Thread Jonathan Ellis
I have a table of log messages. They are mostly in the 100-200 character length, which apparently isn't large enough for PG to want to compress it (length == octet_length). I really need to save disk space. I can store it as a bytea and compress it manually (zlib level 1 compression gives

Re: [GENERAL] forcing compression of text field

2006-12-11 Thread Jeff Davis
On Mon, 2006-12-11 at 09:18 -0700, Jonathan Ellis wrote: I have a table of log messages. They are mostly in the 100-200 character length, which apparently isn't large enough for PG to want to compress it (length == octet_length). I really need to save disk space. I can store it as a bytea

Re: [GENERAL] forcing compression of text field

2006-12-11 Thread Scott Marlowe
On Mon, 2006-12-11 at 10:18, Jonathan Ellis wrote: I have a table of log messages. They are mostly in the 100-200 character length, which apparently isn't large enough for PG to want to compress it (length == octet_length). I really need to save disk space. I can store it as a bytea and

Re: [GENERAL] forcing compression of text field

2006-12-11 Thread Tom Lane
Scott Marlowe [EMAIL PROTECTED] writes: On Mon, 2006-12-11 at 10:18, Jonathan Ellis wrote: I have a table of log messages. They are mostly in the 100-200 character length, which apparently isn't large enough for PG to want to compress it (length == octet_length). I really need to save disk