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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.