> -----Original Message-----
> From: majordomo-owner(at)hub(dot)org [mailto:majordomo-owner(at)hub(dot)org]On Behalf
> Of Don Baccus
> Whatever ... in this particular case - referential integrity
> with MATCH <unspecified> and MATCH PARTIAL and multi-column
> foreign keys - performance will likely drop spectacularly once the
> leading column is NULL, while (say) with Oracle you'd expect much
> less of a performance hit.
As for NULL,it seems possible to look up NULL keys in a btree index
because NULL == NULL for btree indexes.
I've wondered why PostgreSQL's planner/executor never looks up
indexes for queries using 'IS NULL'.
In response to
pgsql-hackers by date
|Next:||From: Daniele Medri||Date: 2000-03-31 10:34:39|
|Subject: Re: ...copy hack|
|Previous:||From: Michael Meskes||Date: 2000-03-31 10:02:45|
|Subject: Re: BIT datatype|