> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance