NavigationContentFooter
Suggest an edit

Encryption at rest performance benchmark on Database Instances

Reviewed on 19 December 2024Published on 19 December 2024

In December 2024, the Scaleway Managed Databases team ran tests on DB-POP2-4C-16G Instances in a Private Network using pgbench. Several workloads (including read, oltp and large loads) were simulated with several scale factors (from 1M rows to 200M rows) and concurrent database connections set to 10. They measured the impact of encryption at rest on transactions, per second and latency.

Important

For more information on pgbench transactions, refer to the “What is the ‘Transaction’ actually performed in pgbench?” section of the official pgbench documentation.

Note

The workloads applied simulate heavy usage scenarios for the purposes of testing. During the beta of encryption at rest, no performance issues were raised by users. If you would like to share your own benchmarks with our team, feel free to reach out to us in the #database channel of the Scaleway Slack community.

The table below compares the different workload and setup combinations and indicates the performance results of each:

Workload TypeSetupScale FactorPerformance Impact
Read WorkloadsStandalone10No impact
Standalone2000No real impact with or without encryption at rest
HA200020-30% impact, likely due to disk writes being replicated. Refer to this blogpost to learn more about disk writes in read operations.
OLTP WorkloadsStandaloneAny15% performance drop with encryption at rest activated
HA1015% performance drop
HA2000Up to 30% performance drop
Large Data Load (29 GB)StandaloneAny10% additional latency
HAAny40% additional latency due to semi-sync replication and encryption overhead
Was this page helpful?
API DocsScaleway consoleDedibox consoleScaleway LearningScaleway.comPricingBlogCareers
© 2023-2024 – Scaleway