Re: [HACKERS] type coerce problem with lztext

At 01:03 PM 2/27/00 +0100, Jan Wieck wrote:
>Well,
>
>    LZTEXT  is there again, and pg_rewrite uses it for action and
>    qual strings. This is what it tells:
>
>    pgsql=# select rulename, length(ev_action), octet_length(ev_action)
>    pgsql-#   from pg_rewrite;
>        rulename    | length | octet_length
>    ----------------+--------+--------------
>     _RETpg_user    |   3043 |          855
>     _RETpg_rules   |   3074 |         1139
>     _RETpg_views   |   4261 |         1252
>     _RETpg_tables  |   5187 |         1338
>     _RETpg_indexes |   3525 |         1122
>    (5 rows)
>
>    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!

This will greatly help counter 7.0's "rule length explosion". 

Thanks.




- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.