Skip site navigation (1) Skip section navigation (2)

Re: partitioned tables query not using indexes

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: partitioned tables query not using indexes
Date: 2010-02-28 20:29:14
Message-ID: 4B8AD21A.2020904@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
> 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

In response to

Responses

pgsql-performance by date

Next:From: xu feiDate: 2010-02-28 20:42:09
Subject: full text search index scan query plan changed in 8.4.2?
Previous:From: Josh BerkusDate: 2010-02-28 20:19:51
Subject: Estimation issue with partitioned tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group