> Try doing a select against mastertab and you will see that it only
> selects from the correct partitions. Look at constraint_exclusion
> parameter, which needs to be set on for this to work.
Ah - constraint_exclusion is the correct param, not enable_constraint_exclusion
(as stated in http://www
On Mon, 2005-10-31 at 21:02 +0100, Mikael Carneholm wrote:
> So far so good. Now, the part where it fails to be useful (performance wise)
> is when you want to make sure a select query only scans the relevant
> partition(s), as it's not possible to create a conditional SELECT rule using
> an INS
Hi,
I did a partially successful attempt at creating a partitioned table + two
subpartitions in Pg8.1b inspired by the method used by Bizgres (see
http://www.bizgres.org/assets/docs/html/tblpartn.htm)
I.e:
CREATE TABLE parttest.mastertab
(
id serial not null,
datecol date not null,
CONST
