Re: [HACKERS] Rule plan size for views?

Vadim B. Mikheev <vadim@sable.krasnoyarsk.su>

From: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
To: Bruce Momjian <maillist@candle.pha.pa.us>
Cc: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>, jwieck@debis.com, darrenk@insightdist.com, pgsql-hackers@postgreSQL.org
Date: 1998-03-03T01:43:38Z
Lists: pgsql-hackers
Bruce Momjian wrote:
> 
> > I added a few nodes (maybe two?), _and_ added some call-outs to existing nodes to
> > follow their children down. This stuff can be bracketed with debugging #ifdef's; it
> > was very helpful for me when debugging but it isn't good if they are adding
> > unnecessary limitations on sizes. The additional nodes I added are a "don't care";
> > it's the additional printing of child nodes (fields of existing structures) which
> > is loading things down.
> 
> The stuff is in nodes/outfuncs.c, and is used in EXPLAIN VERBOSE.  I
> question whether your structures would actually be output as part of a
> rule.
> 
> I hesitate to remove any of the outfuncs stuff.  It is very useful, and
> if it is missing, things are harder to debug.  Adding the fields I did
> helped solve several problems I had when testing subselects, and I know
> Vadim uses that output too.  Shame it goes into the rule, but hard to
> imagine why the rule would not need it, except for fields that are only
> used by the parser, but I think we need to be complete.  A better
> solution would be to allow rewrite rules to span multiple blocks, or a
> least allow them to take the space of two blocks.

Or use LO.

Vadim