Re: Dealing with complex queries - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Dealing with complex queries
Date
Msg-id 20030204125954.GA3239@wolff.to
Whole thread Raw
In response to Dealing with complex queries  (Francisco Reyes <lists@natserv.com>)
Responses Re: Dealing with complex queries
List pgsql-general
On Mon, Feb 03, 2003 at 16:32:10 -0500,
  Francisco Reyes <lists@natserv.com> wrote:
> Any hints suggestions on dealing with complex queries.

>         substring(ppl.carried_as from 1 for 3)
>                 = substring(jc.last from 1 for 3) and

Joining on substrings is a good sign that your design needs rethinking.
This indicates that your data isn't normalized and it isn't going to
be particularly fast test (though I didn't check to see if it is a bottleneck
for the particular query you are doing).

pgsql-general by date:

Previous
From: mjoseph@inautix.com
Date:
Subject: Large objects - SOS
Next
From: Bruno Wolff III
Date:
Subject: Re: Postgres server output logfile