... | ... | @@ -8,7 +8,7 @@ Here we discuss what we usually are interested in when we conduct a database exp |
|
|
|
|
|
How many checkpoints happened? How many of them were forced? What was their frequency? How much data was written by the checkpointer process, by bgwriter, by backends? What were the average rates of writing?
|
|
|
|
|
|
- it looks like we covered this, getting the snapshot of `pg_stat_bgwriter` (and resetting statistics, including `pg_stat_reset_shared('bgwriter')`: https://gitlab.com/postgres-ai-team/nancy/blob/master/nancy_run.sh#L1502)
|
|
|
- it looks like we covered this, getting the snapshot of `pg_stat_bgwriter` (and resetting statistics using `pg_stat_reset_shared('bgwriter')` immediately before applying workload: https://gitlab.com/postgres-ai-team/nancy/blob/master/nancy_run.sh#L1502)
|
|
|
|
|
|
- additionally, we might want to analyze logs, getting actual information from there (the "workload" log is among artifacts already).
|
|
|
|
... | ... | |