Message-ID: <1493206557.30225.5.camel@kth.se>
Subject: Re: Slow query with 3 table joins
From: Johan Fredriksson <eskil@kth.se>
To: pgsql-performance@postgresql.org
Date: Wed, 26 Apr 2017 13:35:57 +0200
In-Reply-To: 
 <CAMgh6pJ_i+w-xP+FJiNbz6pSKJDbHnaYPyh9bnb5xUYr4PBH6g@mail.gmail.com>
References: 
	<CAMgh6pJ9KLab1t7iqcr=7m4xL0V1kPyceanamxAywSYs+Cxn=Q@mail.gmail.com>
	 <CAMgh6pKk+hdnjaWxJ5mr0MpmbK-i-UHq35QB2C9LorXRNUkuEw@mail.gmail.com>
	 <1493187867.30225.3.camel@kth.se>
	 <CAMgh6pJ_i+w-xP+FJiNbz6pSKJDbHnaYPyh9bnb5xUYr4PBH6g@mail.gmail.com>
Organization: KTH
Content-Type: text/plain; charset="UTF-8"
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org


> 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


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