Re: What constitutes a complex query

Поиск
Список
Период
Сортировка
От Steve Atkins
Тема Re: What constitutes a complex query
Дата
Msg-id 8F6A6B57-B7C4-4E05-8971-6B388C593499@blighty.com
обсуждение исходный текст
Ответ на What constitutes a complex query  (Justin <justin@emproshunts.com>)
Список 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 по дате отправления:

Предыдущее
От: Shaun Thomas
Дата:
Сообщение: Re: need to speed up query
Следующее
От: "Richard Broersma"
Дата:
Сообщение: Re: What constitutes a complex query