Home

Nemesis measurements

On this page you can find the graphs generated from the datasets that were collected by Nemesis when performing benchmarks on various schema evolution scenarios using a number of Data Definition Language (DDL) statements, such as ALTER TABLE ... statements.

Adding a nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Adding a non-nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Renaming a nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Renaming a non-nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Drop a nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Drop a non-nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Make a non-nullable column nullable

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Make a nullable column non-nullable

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Make a non-nullable column nullable

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Set default expression of nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Set default expression of non-nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Modify datatype on a nullable column

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Modify datatype on a non-nullable column

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Modify datatype from integer to text

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Create a foreign key constraint on a nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Create a foreign key constraint on a non-nullable column

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Create an index

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Rename an existing index

PostgreSQL 9.3

PostgreSQL 9.4

Drop an existing index

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4

Rename existing table

MySQL 5.5

MySQL 5.6

PostgreSQL 9.3

PostgreSQL 9.4

QuantumDB on PostgreSQL 9.4