# Genesys Quality Management Suite 8.1.520 : Database Type

The type of database chosen depends on the size of recording needs and on how much evaluation and retrieval of media is needed.

## PostgreSQL

For small to medium recording solutions the default PostgreSQL database is adequate and is the most cost effective way of storing calls, screen captures and related data. The PostgreSQL database is limited to around 200 million call records; above this number queries are not returned within acceptable limits.

## Oracle

For larger solutions with over 50 million call records, Quality Manager and many input/output operations per second (IOPS) an Oracle database should be considered. An Oracle database is also often part of an enterprise database strategy, enabling more efficient corporate maintenance and backup procedures to be used.

An Oracle database can be used as the only configured database (storing all system and call data), or it can be used in addition to the embedded PostgreSQL database for specific data, such as call information. These database mappings can be modified after Genesys Quality Management Suite installation, although a system restart is required after each change is made.
A typical case for the use of mixed database deployments is a larger cluster scenario, where multiple smaller distributed recorder installations (using embedded PostgreSQL databases) provide call data to a central Oracle-powered Replay Server.

Icon

All Oracle-specific operations such as database installation, setup and maintenance are the responsibility of the customer; direct support isn't provided for maintaining Oracle databases as we do for the embedded PostgreSQL database.

Genesys Genesys Quality Management Suite 8.1.520 supports Oracle database versions 11g and above.