EXP-001PLANNED

PostgreSQL on Nigerian Cloud Infrastructure

Establish a baseline for PostgreSQL performance and operational characteristics on Nigerian-hosted cloud infrastructure.

AUTHOR: Hexcore Engineering Lab
UPDATED: 2026-10-04
EVIDENCE STATE: HYPOTHESISED / PLANNED

01 / Research question

How does PostgreSQL behave under repeatable transactional workloads on Nigerian-hosted cloud infrastructure?

Hypothesis — not a finding

Storage, instance shape and connection concurrency will materially affect tail latency before average throughput becomes the limiting signal.

02 / Architecture

System topologyBaseline pending

Load generation

Workload runner

Synthetic transactions

Nigerian infrastructure

PostgreSQL

Test database

Measurement plane

Telemetry

Metrics + traces

Conceptual architecture · final environment to be documented

03 / Environment

Infrastructure: MTN Cloud Nigeria — test environment
Database: PostgreSQL — version and shape to be recorded
Data: Synthetic only; no customer or production data
Region / zone: To be documented before execution

04 / Methodology

A repeatable synthetic transactional workload with read, write and mixed profiles. Dataset shape, client concurrency and warm-up periods will be published with the results.

01Provision and document a repeatable environment
02Load a fixed synthetic dataset
03Establish idle and single-client baselines
04Run controlled concurrency steps
05Test backup and restore paths
06Repeat, analyse and publish limitations

05 / Measurements

M-01

Query latency

M-02

p50 / p95 / p99 transaction latency

M-03

Throughput

M-04

CPU and memory

M-05

Storage I/O

M-06

Connection behaviour

M-07

Backup duration

M-08

Restore duration

M-09

Infrastructure cost

06 / Results & observations

Results pending

This experiment has not yet been executed.

This space will contain measured results, observations and failure modes after repeated runs and methodological review. No benchmark values are available yet.

07 / Limitations

—No results have been collected
—Instance types and storage profiles are not yet fixed
—A single provider cannot represent all Nigerian infrastructure

08 / Reproduction & artefacts

Test harnessPending

Raw measurementsPending

Analysis notebookPending

Commands, configuration, dataset generators and raw data will be linked here when they exist.

Related experiments

EXP-002PLANNED

Conceptual topology
Baseline pending

Data localisation

Split-Cloud Transaction Architecture

Measure the consequences of running application compute outside Nigeria while maintaining transaction data on Nigerian infrastructure.

Learn more