Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Fri, 2021-03-26 at 14:00 -0400, Jacque Edmund wrote:
>> I've already seen that my current set of FK relationships between < 100 tables and data footprint
>> has yielded very large lookup times for the underlying referential integrity of the FKs to vet
>> whether it can DELETE a row or not based on its FK relationships.
> I would be surprised if correctly indexed foreign keys would slow deletes down so that
> the performance becomes intolerable.
Deletes being slow often means that you don't have an index on the
referencing column(s). PG requires you to have an index on the referenced
columns, but not on the other side of the FK relationship.
regards, tom lane
