You can enable set delayed_commit for a database or for a session, with the session setting overruling the database setting. This means that a session that enables the option has delayed_commit enabled regardless of the database setting.