Postgres Pro
Downloads
Home   >   mailing lists

Re: query against single partition uses index, against master table does seq scan - Mailing list pgsql-performance

From Tom Lane
Subject Re: query against single partition uses index, against master table does seq scan
Date
Msg-id 24073.1474510287@sss.pgh.pa.us
Whole thread Raw
In response to query against single partition uses index, against master table does seq scan  (Mike Broers <mbroers@gmail.com>)
Responses Re: query against single partition uses index, against master table does seq scan  (Mike Broers <mbroers@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher
Next
From: Mike Broers
Date:
Subject: Re: query against single partition uses index, against master table does seq scan