Craig Ringer wrote:
Tom Lane wrote:
No, not at the moment. In principle the planner could look for such
duplicates, but it'd be wasted cycles so much of the time that I'd be
loath to do it.
Good point - there are better places to spend time, and I imagine it'd
be an expensive thing to check
Tom Lane wrote:
No, not at the moment. In principle the planner could look for such
duplicates, but it'd be wasted cycles so much of the time that I'd be
loath to do it.
Good point - there are better places to spend time, and I imagine it'd
be an expensive thing to check too.
There is work
Craig Ringer <[EMAIL PROTECTED]> writes:
> Is there any way to get postgresql to detect such repeated query parts
> and evaluate them only once?
No, not at the moment. In principle the planner could look for such
duplicates, but it'd be wasted cycles so much of the time that I'd be
loath to do i
Hi
I've been wondering about postgresql's handling of repeated subqueries
in statements for a while, and thought I'd ask here.
If the exact same subquery appears in multiple places in a complex
query, it seems to be executed separately each time it appears. I'm
wondering if there's any way,
