Re: What constitutes a complex query - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: What constitutes a complex query
Date
Msg-id dcc563d10805061037t6466b766t66ede75d876f2847@mail.gmail.com
Whole thread Raw
In response to Re: What constitutes a complex query  (Justin <justin@emproshunts.com>)
List pgsql-performance
On Tue, May 6, 2008 at 11:23 AM, Justin <justin@emproshunts.com> 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.

pgsql-performance by date:

Previous
From: Antoine Baudoux
Date:
Subject: Re: multiple joins + Order by + LIMIT query performance issue
Next
From: Greg Smith
Date:
Subject: Re: Possible Redundancy/Performance Solution