Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M53744=pgsql-performance-ar@postgresql.org>)
 id 1a7aee-0005TZ-9Y
 for pgsql-performance@arkaria.postgresql.org; Sat, 12 Dec 2015 03:15:28 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-performance-owner+M53744=pgsql-performance-ar@postgresql.org>)
 id 1a7aed-0001Fb-9o
 for pgsql-performance@arkaria.postgresql.org; Sat, 12 Dec 2015 03:15:27 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <andreas@a-kretschmer.de>)
 id 1a7acz-0007Fn-Al
 for pgsql-performance@postgresql.org; Sat, 12 Dec 2015 03:13:45 +0000
Received: from mailout01.ims-firmen.de ([213.174.32.96])
 by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <andreas@a-kretschmer.de>)
 id 1a7acw-0006Dg-9C
 for pgsql-performance@postgresql.org; Sat, 12 Dec 2015 03:13:44 +0000
Received: from mailin01.ims-firmen.de ([192.168.1.141])
 by mailout01.ims-firmen.de with esmtp
 (envelope-from <andreas@a-kretschmer.de>)
 id 1a7act-0001z1-ia; Sat, 12 Dec 2015 04:13:39 +0100
Received: from [213.174.32.191] (helo=oxweb01.ims-firmen.de)
 by mailin01.ims-firmen.de with esmtpsa (TLSv1:RC4-MD5:128)
 (envelope-from <andreas@a-kretschmer.de>)
 id 1a7act-0000ov-01; Sat, 12 Dec 2015 04:13:39 +0100
Date: Sat, 12 Dec 2015 04:13:38 +0100 (CET)
From: Andreas Kretschmer <andreas@a-kretschmer.de>
Reply-To: Andreas Kretschmer <andreas@a-kretschmer.de>
To: Rick Otten <rottenwindfish@gmail.com>, pgsql-performance@postgresql.org
Message-ID: 
 <770682355.328334.1449890018990.JavaMail.open-xchange@oxweb01.ims-firmen.de>
In-Reply-To: 
 <CAMAYy4JUSRexg_Ex3YH-2tWbyW9u=drBfTZODkuqJGQ82kOj2g@mail.gmail.com>
References: 
 <CAMAYy4LGhyd1yUjBsmhmY7nSgb9rX28r4nad=iuGDQaAUacDFQ@mail.gmail.com>
 <20151211194440.GA14772@tux>
 <CAMAYy4JpF8oAihsqsSvtUcMMetLt=KWVqFrVdChqDwMhKci8gA@mail.gmail.com>
 <1203683949.315121.1449870245520.JavaMail.open-xchange@oxweb02.ims-firmen.de>
 <CAMAYy4KC0DupF=0CtAK+jxruMUC6ssK36uC6wg60Qs3vFmCY1w@mail.gmail.com>
 <1493794655.315218.1449879621677.JavaMail.open-xchange@oxweb02.ims-firmen.de>
 <CAMAYy4JUSRexg_Ex3YH-2tWbyW9u=drBfTZODkuqJGQ82kOj2g@mail.gmail.com>
Subject: Re: partitioned table set and indexes
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Priority: 3
Importance: Medium
X-Mailer: Open-Xchange Mailer v7.6.2-Rev12
X-Originating-Client: com.openexchange.ox.gui.dhtml
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org



> Rick Otten <rottenwindfish@gmail.com> hat am 12. Dezember 2015 um 01:55
> geschrieben:
> 
> 
> Why does it index scan when I use where, but not when I do a join?


difficult to say/guess because of anonymized names and not knowing the real
query. This one? http://explain.depesz.com/s/1es ?
All seqscans are fast, a seqscan isn't evil per se.


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