Tag: Postgres

  • Unindexed Foreign Keys in Oracle and PostgreSQL

    Unindexed Foreign Keys in Oracle and PostgreSQL

    Unindexed Foreign Keys in Oracle and PostgreSQL In Oracle we need to have a index on the foreign key column as soon as we have the intention to delete from the parent row, or a locking situation may block all transactions around the child table. PostgreSQL has a similar way to manage isolation, with MVCC,

    Explore →