Re: [HACKERS] Rule plan size for views?
Darren King <darrenk@insightdist.com>
From: darrenk@insightdist.com (Darren King)
To: pgsql-hackers@postgresql.org
Date: 1998-03-01T00:53:17Z
Lists: pgsql-hackers
> darrenk > Just 'Darren' for short. :) > So when I do it as a select statement the plan can grow larger than 8K > because I can run the SQL command itself. The plan is the internal plan generated by the parser/optimizer. A very short sql statement could generate a very big plan. No real easy way to tell without actually running it. > Has the plan generation changed in the last week? I was able to create > another view in an earlier beta but cannot now. This I don't know. Any little change to the nodes or the parser/optimizer could have bumped you over the limit. > Is there a way to find out the size of the plan? Could add some debugging statements in the rewrite code to show it. Snoop around the src/backend/rewrite directory a little. Darren