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

From Steve Atkins
Subject Re: What constitutes a complex query
Date
Msg-id 8F6A6B57-B7C4-4E05-8971-6B388C593499@blighty.com
Whole thread Raw
In response to What constitutes a complex query  (Justin <justin@emproshunts.com>)
List 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


pgsql-performance by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: need to speed up query
Next
From: "Richard Broersma"
Date:
Subject: Re: What constitutes a complex query