... | ... | @@ -35,3 +35,20 @@ How many times each table was autovacuumed? What was performance impact of it? |
|
|
- pgBadger, or
|
|
|
|
|
|
- [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:
|
|
|
|
|
|
```bash
|
|
|
(
|
|
|
echo "step 1"
|
|
|
# ...
|
|
|
|
|
|
echo "step 2"
|
|
|
) 2>&1 | ts | tee -a logfile.log
|
|
|
``` |
|
|
\ No newline at end of file |