Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

pg_stat_monitor: Stress test

Description

To ensure that pg_stat_monitor is stable:

  1. We should run 100x "installcheck-world" target with pg_stat_monitor loaded,

  2. We should run pgbench for 48 hours at least

These should be run on separate systems. After each run, we should record resource utilisations (RAM specifically) to see if the memory footprint is increasing. We should also assess log for any errors.

pg_stat_monitor should pass these tests without any issues.

How to document

None

How to test

None

Attachments

2

Smart Checklist

Activity

Show:

Diego Fronza November 19, 2021 at 1:50 PM

Regression and Stress test results indicate that this release is stable.

Diego Fronza November 19, 2021 at 1:37 PM
Edited

Ran pgbench for about 40 hours, 8 processes monitored, in each one the memory grows by an average of 20 MB over time then it keeps stable.

X axis is time in seconds.

Y axis is memory in KB.

Diego Fronza November 16, 2021 at 9:12 PM
Edited

make installcheck-world results are ok,  ran 109 iterations without module, 109 with pg_stat_statements (pgss), and 109 with pg_stat_monitor (pgsm), all tests passed, follows an image with results:

Done

Details

Assignee

Reporter

Labels

Components

Fix versions

Priority

Smart Checklist

Created September 24, 2021 at 2:03 PM
Updated March 5, 2024 at 9:35 PM
Resolved November 16, 2021 at 11:38 AM