Re: What constitutes a complex query

From: Steve Atkins <steve(at)blighty(dot)com>
To: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: What constitutes a complex query
Date: 2008-05-06 16:56:16
Message-ID: 8F6A6B57-B7C4-4E05-8971-6B388C593499@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On May 6, 2008, at 8:45 AM, Justin wrote:

> This falls under the stupid question and i'm just curious what other
> people think what makes a query complex?

If I know in advance exactly how the planner will plan the query (and
be right), it's a simple query.

Otherwise it's a complex query.

As I get a better feel for the planner, some queries that used to be
complex become simple. :)

Cheers,
Steve

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Broersma 2008-05-06 16:58:39 Re: What constitutes a complex query
Previous Message Shaun Thomas 2008-05-06 16:43:40 Re: multiple joins + Order by + LIMIT query performance issue