Horton

Re: [HACKERS] type coerce problem with lztext

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jan Wieck <wieck@debis.com>, PostgreSQL HACKERS <pgsql-hackers@postgreSQL.org>
Date: 2000-02-27T19:06:21Z
Lists: pgsql-hackers 
> Yup, TypeCategory was the missing ingredient.  Seems to work now.
> 
> >     Yes, the 3043 bytes long rule action string got stored in 855
> >     bytes  in  pg_rewrite.  That's 71.9% compression rate on this
> >     attempt!
> 
> Over all the rules in the regression test database, I see:
> 
> regression=# select sum(length(ev_action)),sum(octet_length(ev_action)) from pg
> _rewrite;
>   sum   |  sum
> --------+-------
>  105270 | 38091
> (1 row)
> 
> or about 64% compression.  Not bad...

We clearly needed this for 7.0 because of the larger plans.  Good thing
Jan had it available, becuase I can imagine some major headaches for
people without it.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026