@@ -35,3 +35,20 @@ How many times each table was autovacuumed? What was performance impact of it?
...
@@ -35,3 +35,20 @@ How many times each table was autovacuumed? What was performance impact of it?
- pgBadger, or
- pgBadger, or
- [TODO] K*** reports of postgres-checkup
- [TODO] K*** reports of postgres-checkup
# Manual experiments
When conducting experiments manually (with or without Nancy) it is important to use the following best practices:
1. Always create scripts – automate every step, even if it looks like a one-time operation.
1. Document everything in GitLab Issues. Put scripts there or into repository and provide links. Think about visibility and people who will need to follow your steps.
1. Use logs! The best way (with `moreutils` package installed) is to use something like this: