From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
---|---|
To: | Jan Wieck <wieck(at)debis(dot)com>, PostgreSQL HACKERS <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] type coerce problem with lztext |
Date: | 2000-02-27 15:34:07 |
Message-ID: | 3.0.1.32.20000227073407.00fa97b0@mail.pacifier.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-02-27 17:55:45 | Re: [HACKERS] type coerce problem with lztext |
Previous Message | Bruce Momjian | 2000-02-27 14:50:45 | Re: [HACKERS] type coerce problem with lztext |