forked from mtusi2026/mtusi2026lab4
33 lines
1.1 KiB
Plaintext
33 lines
1.1 KiB
Plaintext
Research project: lab2-research-85021a09d9
|
|
Measuring two indexes on the same 100000 messages, three repeats...
|
|
{
|
|
"chat_only": {
|
|
"insert_100000_median_ms": 1386.7587500000127,
|
|
"index_bytes": 671744,
|
|
"wal_bytes_median": 38822560,
|
|
"queries": 180,
|
|
"errors": 0,
|
|
"concurrency": 1,
|
|
"p50_ms": 1.6852079999978287,
|
|
"p95_ms": 7.566457999985232,
|
|
"p99_ms": 46.40233399999261,
|
|
"successful_sql_rps": 282.01364182715855
|
|
},
|
|
"history": {
|
|
"insert_100000_median_ms": 1404.4910420000178,
|
|
"index_bytes": 7315456,
|
|
"wal_bytes_median": 43108512,
|
|
"queries": 180,
|
|
"errors": 0,
|
|
"concurrency": 1,
|
|
"p50_ms": 0.22610399997802233,
|
|
"p95_ms": 0.29704099995342403,
|
|
"p99_ms": 0.3384169999662845,
|
|
"successful_sql_rps": 4322.810483886352
|
|
}
|
|
}
|
|
PASS: backup 0.54s; restore 0.68s; 100000 messages, all hashes and 12 samples match
|
|
PASS: restored into a different container and fresh volume; one post-backup commit is absent as expected
|
|
Results: evidence/research.json, evidence/query-plans.json; dump stays outside Git in backups/
|
|
Removed only temporary research project: lab2-research-85021a09d9
|