Re: [PERFORM] Slow query with 3 table joins - Mailing list pgsql-performance

From Johan Fredriksson
Subject Re: [PERFORM] Slow query with 3 table joins
Date
Msg-id 1493206557.30225.5.camel@kth.se
Whole thread Raw
In response to Re: [PERFORM] Slow query with 3 table joins  (Alessandro Ferrucci <alessandroferrucci@gmail.com>)
List pgsql-performance
> Hi Eskil -
>
>
> The I believe the id-field you're referring to is the UNIT.UNIT_ID, I
> could change this to a varchar, however that column is not used in the
> query in question, so that wouldn't have any effect on the query's
> performance.

Sorry, I did not notice that the column "unit_id" existed in both "unit"
and "field" tables.

        / Eskil





pgsql-performance by date:

Previous
From: Alessandro Ferrucci
Date:
Subject: Re: [PERFORM] Slow query with 3 table joins
Next
From: Gerardo Herzig
Date:
Subject: Re: [PERFORM] Slow query with 3 table joins