Re: [SQL] Sequential scan evaluating function for each row, seemingly needlessly

2010-09-07 Thread Tom Lane
Bryce Nesbitt writes: > On psql 8.3.9, I ran a limited query limited to 5 results. There was a > moderately expensive function call > which I expected to be called 5 times, but was apparently called for > each row of the sequential scan. Why? Given the plan: > Limit (cost=19654.53..19654.

[SQL] Sequential scan evaluating function for each row, seemingly needlessly

2010-09-07 Thread Bryce Nesbitt
On psql 8.3.9, I ran a limited query limited to 5 results. There was a moderately expensive function call which I expected to be called 5 times, but was apparently called for each row of the sequential scan. Why? preproduction=> explain analyze select url(context_key) from extractq order b