> On 9 Jan 2017 1:46 a.m., "Scott Marlowe" <scott.marlowe@gmail.com> wrote:
>> I.e. the query planner does NOTHING different for a select from a view
>> than if you just run the query that makes the up the view by hand.
On 9 January 2017 at 08:22, David L <segedunum@actuaria.co.uk> wrote:
> Yes I know. That's the point.
At the moment, nobody can see a reason for the behaviour you are describing.
To take this further you'd need to show evidence or a repeatable test
that showed the effect you are describing is real, even if nobody here
can understand what would be causing it, yet.
Perhaps try executing your test case a million times and report on any
tests that are very substantially longer in the way you describe?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services