Rikard Pavelic writes:
> Is it possible to speed up deletes which have null references so they don't
> check if a reference is valid?
You're thinking about the problem backwards. Since the table is
self-referential, each row is both a PK (referenced) row and an FK
(referencing) row. In its rol
Is it possible to speed up deletes which have null references so they don't
check if a reference is valid?
I had this scenario:
--large table not referenced from other places
CREATE TABLE large_table
(
id bigserial primary key,
ref_1 bigint not null,
ref_2 bigint not null,
at_1 timestamptz n
