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_leng

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 > s

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 sav

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 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 byte