Nichlas =?iso-8859-1?Q?L=F6fdahl?= <[EMAIL PROTECTED]> writes:
> I have a partial index (btree(col) WHERE col > 0) on table2 ('col' contains
> alot of NULL-values).
Advertising
> There's also a foreign key on the column pointing to the primary key of
> table1 (ON UPDATE CASCADE ON DELETE SET NULL). During update/delete, it seems
> like it cannot use the partial index to find corresponding rows matching the
> foreign key (doing a full seqscan instead)?
> Is there any special reason for not letting the planner use the partial index
> when appropriate?
It doesn't know it's appropriate. There's nothing constraining the FK
to be positive, after all.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
