Re: [HACKERS] type coerce problem with lztext

> 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,
Pennsylvania19026