| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Justin <justin(at)emproshunts(dot)com> |
| Cc: | "Craig James" <craig_james(at)emolecules(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: What constitutes a complex query |
| Date: | 2008-05-06 17:37:59 |
| Message-ID: | dcc563d10805061037t6466b766t66ede75d876f2847@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, May 6, 2008 at 11:23 AM, Justin <justin(at)emproshunts(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-05-06 17:39:27 | Re: Possible Redundancy/Performance Solution |
| Previous Message | Antoine Baudoux | 2008-05-06 17:24:28 | Re: multiple joins + Order by + LIMIT query performance issue |