Trying to gain peace of mind by using constraints


Ivan Frolkov

Postgres Professional

Consulting Engineer

13:20 (UTC+3) , russian

There's a common delusion that constraints should never be used as they affect performance in a negative way, interfere with regular work, and are, all in all, useless. The database is commonly perceived as just a storage without any logic. I'll explain why it isn't so and what this careless approach may lead to.