On Sun, Feb 28, 2010 at 12:29:14PM -0800, Josh Berkus wrote:
> > 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
Does this help? I have an empty base table without indexes and partitions
underneath that do have the index. I did not think that an index on the
parent table did anything.
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2010-02-28 22:41:46|
|Subject: Re: [HACKERS] full text search index scan query plan changed in 8.4.2?|
|Previous:||From: xu fei||Date: 2010-02-28 20:42:09|
|Subject: full text search index scan query plan changed in 8.4.2?|