On Tue, May 6, 2008 at 11:23 AM, Justin <justin@xxxxxxxxxxxxxxx> wrote: > > > Craig James wrote: > > > Justin wrote: > > > > > This falls under the stupid question and i'm just curious what other > people think what makes a query complex? > > > > > > > There are two kinds: > > > > 1. Hard for Postgres to get the answer. > > > this one Sometimes, postgresql makes a bad choice on simple queries, so it's hard to say what all the ones are that postgresql tends to get wrong. Plus the query planner is under constant improvement thanks to the folks who find poor planner choices and Tom for making the changes.
