> On 9 Jan 2017 1:46 a.m., "Scott Marlowe" <scott.marlowe@xxxxxxxxx> 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@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
