What are ACID properties? Is PostgreSQL compliant with ACID?

ACID stands for Atomicity, Consistency, Isolation, Durability. They are database transaction properties which are used for guaranteeing data validity in case of errors and failures.

  • Atomicity: This property ensures that the transaction is completed in all-or-nothing way.
  • Consistency: This ensures that updates made to the database is valid and follows rules and restrictions.
  • Isolation: This property ensures integrity of transaction that are visible to all other transactions.
  • Durability: This property ensures that the committed transactions are stored permanently in the database.

PostgreSQL is compliant with ACID properties.