Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] How could I improve a query with a function in the join clause? - Mailing list pgsql-sql

From Andreas Kretschmer
Subject Re: [SQL] How could I improve a query with a function in the join clause?
Date
Msg-id 57821318-D207-49C0-A499-9F2DE5745F9B@a-kretschmer.de
Whole thread Raw
In response to [SQL] How could I improve a query with a function in the join clause?  (Daniel Franco <dpinheirofranco@gmail.com>)
List pgsql-sql
Tree view 
On 14 September 2017 01:55:48 GMT+02:00, Daniel Franco <dpinheirofranco@gmail.com> wrote:
>I'm trying to improve the performance of a query in PostgreSQL with
>lots of
>left joins that uses the lower function in the join condition. The
>database
>version is 8.3.
>
>
>
>What is the best option for optimizing this type of query?
>
>Thanks in advance.


Upgrade to an actual Version.


Andreas


--
2ndQuadrant - The PostgreSQL Support Company


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

pgsql-sql by date:

Previous
From: Daniel Franco
Date:
Subject: [SQL] How could I improve a query with a function in the join clause?
Next
From: srilinux
Date:
Subject: [SQL] Query is executing but giving error when using with shell scripting