Re: [HACKERS] LZTEXT for rule plan stings - Mailing list pgsql-hackers

From Don Baccus
Subject Re: [HACKERS] LZTEXT for rule plan stings
Date
Msg-id 3.0.1.32.20000226064623.00fa1250@mail.pacifier.com
Whole thread Raw
In response to Re: [HACKERS] LZTEXT for rule plan stings  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] LZTEXT for rule plan stings
List pgsql-hackers
At 01:27 AM 2/26/00 -0500, Tom Lane wrote:
>Don Baccus <dhogaza@pacifier.com> writes:
>> Here's the test case:
>
>Hmm.  I get a rule string exceeding 8K out of this (in current sources),
>as checked by breakpointing at InsertRule() in rewriteDefine.c and
>looking at 'actiontree'.
>
>What's your basis for asserting the rule is only ~ 1K?

I looked at the string dumped by pg_dump and it didn't appear to be
anywhere near 8KB, so I presumed that the actual data stuffed into
the rule is larger than whatever gets dumped out as the source
representation.

I've never looked at the implementation of rules, so it's unclear
to me just exactly what is being saved and just how much of it
using lzText would impact.

I had breakpointed the debugger at first and that's why I first
said apparently the rule string was > 8KB.  Then I looked at 
pg_dump output and had doubts that the answer was this simple...



- 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.
 


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] LZTEXT for rule plan stings
Next
From: Don Baccus
Date:
Subject: Re: [HACKERS] LZTEXT for rule plan stings