Postgres Pro
Downloads
Home   >   mailing lists

Re: partitioned tables query not using indexes - Mailing list pgsql-performance

From Josh Berkus
Subject Re: partitioned tables query not using indexes
Date
Msg-id 4B8AD21A.2020904@agliodbs.com
Whole thread Raw
In response to partitioned tables query not using indexes  (Kevin Kempter <kevink@consistentstate.com>)
Responses Re: partitioned tables query not using indexes  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-performance
Tree view 
> However the same query against the base table when specifying the check
> constraint key in the where clause produces sequential scans:

Does the "master" table have the same indexes as the slave partitions?

--Josh Berkus

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Estimation issue with partitioned tables
Next
From: Kenneth Marshall
Date:
Subject: Re: partitioned tables query not using indexes