PostgreSQL Database
The C3 Agentic AI Platform offers various database solutions:
- Cassandra: A BASE-compliant database optimized for high availability and performance. Supports large data loads with low latency reads and writes, eventual consistency, and flexible schema design.
- PostgreSQL: An ACID-compliant relational database that suits structured data and SQL operations.
- H2: An ACID-compliant database primarily for testing and single node environments. Extends PostgreSQL functionality with simplified setup and reduced resource requirements.
Additionally, the platform supports other KV store alternatives and file system storage. To learn more about alternative data storage solutions and cost and performance considerations, see Specify a KV Store.
The following sections provide additional information about PostgreSQL database features.
Database characteristics
The following characteristics summarize PostgreSQL as a supported database:
- Fault tolerant: Provides built-in mechanisms to recover from hardware failures and maintain data integrity.
- Scalable to number of users and quantity of data: Handles increasing workloads through vertical scaling.
- Supports inheritance: Allows table inheritance for creating hierarchical data structures and shared attributes.
For more information about PostgreSQL and its limitations, see Specify a KV Store.
Feature support
PostgreSQL supports table-level locks and various index configuration options:
- To learn more about locks in PostgreSQL, see the PostgreSQL Lock documentation.
- To learn more about indexes in PostgreSQL, see the PostgreSQL Indexes documentation.
- For C3 AI best practices and information on using indexes in the platform, see Database Indexes