From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike Broers <mbroers@gmail.com>
cc: pgsql-performance@postgresql.org
Subject: Re: query against single partition uses index,
 against master table does seq scan
In-reply-to: 
 <CAB9893h=eDDHZ9m-0ENPQzqVdqjWBHhmiVCpfSZK7oUZVYHfXw@mail.gmail.com>
References: 
 <CAB9893h=eDDHZ9m-0ENPQzqVdqjWBHhmiVCpfSZK7oUZVYHfXw@mail.gmail.com>
Comments: In-reply-to Mike Broers <mbroers@gmail.com>
	message dated "Wed, 21 Sep 2016 11:53:15 -0500"
Date: Wed, 21 Sep 2016 22:11:27 -0400
Message-ID: <24073.1474510287@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Mike Broers <mbroers@gmail.com> writes:
> Hello, I am curious about the performance of queries against a master table
> that seem to do seq scans on each child table.  When the same query is
> issued at a partition directly it uses the partition index and is very
> fast.

What PG version is that?  For me, everything since 9.0 seems to be willing
to consider the type of plan you're expecting.

			regards, tom lane


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