From: | darrenk(at)insightdist(dot)com (Darren King) |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Rule plan size for views? |
Date: | 1998-03-01 00:53:17 |
Message-ID: | 9803010053.AA75582@ceodev |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 1998-03-01 02:07:42 | RE: [HACKERS] Current 6.3 issues |
Previous Message | Darren King | 1998-03-01 00:45:27 | Tutorial fixed. |