On 2/28/10 1:51 PM, Kenneth Marshall wrote: > 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. I'm not sure that it does, but "try it and see" is easier than reading the planner code. --Josh Berkus -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
