Re: Optimizer questions
| От | Simon Riggs |
|---|---|
| Тема | Re: Optimizer questions |
| Дата | |
| Msg-id | CANP8+j+8bLSvO1PfJykHCc28Dj7=dWpemjGa0ABsRXGYqx7DVw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Optimizer questions (David Rowley <david.rowley@2ndquadrant.com>) |
| Список | pgsql-hackers |
On 6 January 2016 at 09:03, David Rowley <david.rowley@2ndquadrant.com> wrote:
Currently, the FunctionScan executes until it decides to stop. Then later the LIMIT is applied.
To change this, you'd need to pass down the LIMIT value into the FunctionScan node, as is already done between Limit/Sort nodes.
On the FunctionScan, you can set the max_calls value in the FuncCallContext, but currently that isn't enforced.
--
It seems worthwhile to investigate how we might go about improving this so that the evaluation of the target list happens after LIMIT, at least for the columns which are not required before LIMIT.
To change this, you'd need to pass down the LIMIT value into the FunctionScan node, as is already done between Limit/Sort nodes.
On the FunctionScan, you can set the max_calls value in the FuncCallContext, but currently that isn't enforced.
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: