Re: [HACKERS] Rule plan size for views?

Поиск
Список
Период
Сортировка
От darrenk@insightdist.com (Darren King)
Тема Re: [HACKERS] Rule plan size for views?
Дата
Msg-id 9803010053.AA75582@ceodev
обсуждение исходный текст
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: darrenk@insightdist.com (Darren King)
Дата:
Сообщение: Tutorial fixed.
Следующее
От: t-ishii@sra.co.jp (Tatsuo Ishii)
Дата:
Сообщение: RE: [HACKERS] Current 6.3 issues