Re: query against single partition uses index, against master table does seq scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Broers <mbroers(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: query against single partition uses index, against master table does seq scan
Date: 2016-09-22 02:11:27
Message-ID: 24073.1474510287@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mike Broers <mbroers(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mike Broers 2016-09-22 04:09:12 Re: query against single partition uses index, against master table does seq scan
Previous Message Jim Nasby 2016-09-21 21:48:41 Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher