Re: How could I improve a query with a function in the join clause?

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-sql(at)postgresql(dot)org,Daniel Franco <dpinheirofranco(at)gmail(dot)com>
Subject: Re: How could I improve a query with a function in the join clause?
Date: 2017-09-14 01:40:50
Message-ID: 57821318-D207-49C0-A499-9F2DE5745F9B@a-kretschmer.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 14 September 2017 01:55:48 GMT+02:00, Daniel Franco <dpinheirofranco(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message srilinux 2017-09-14 15:58:07 Query is executing but giving error when using with shell scripting
Previous Message Daniel Franco 2017-09-13 23:55:48 How could I improve a query with a function in the join clause?