Purpose:
RegistrationReview current Postgres configuration and how it conforms to the current recommended/optimal settings.
Process:
Search multiple sources including wikis, videos and official documentation to source the common recommended settings and suggested tweaks to reach optimal performance.
Results:
Recycling WAL files. A WAL file is a Write Ahead Log file. The default for postgres is to recycle these files instead of creating new files. This is done by renaming them.
On Cloud and COW file systems it is often optimal to create new files instead of renaming.
# | Test | Units | Base | New Parameter Test | Difference |
|---|---|---|---|---|---|
1 | Registration | CM-handles/second | 65.145 | 65.734 | 1% |
2 | DeRegistration | CM-handles/second | 414.503 | 406.904 | -2% |
3a | Id Search no filter | milliseconds | 251.698 | 247.557 | 1.5% |
3b | ID Search Module filter | milliseconds | 229.158 | 221.479 | 3% |
3c | ID search Property Feature | milliseconds | 605.919 | 598.145 | |
3d | ID Search CPS Path | milliseconds | 603.150 | 590.957 | |
3e | ID search Trust level | milliseconds | 2045.283 | 2003.485 | |
4a | CM Handle search no filter | milliseconds | 2253.802 | 2200.563 | |
4b | CM Handle Search Module filter | milliseconds | 3440.510 | 3435.791 | |
4c | CM Handle search Property filter | milliseconds | 3767.822 | 3770.819 | |
4d | CM Handle search CPS Path filter | milliseconds | 3802.582 | 3792.978 | |
4e | CM Handle search Trust level filter | milliseconds | 5291.188 | 5335.575 | |
5a | P/T Read | milliseconds | 18.177 | 18.089 | |
5b | P/T Read Alternate ID | milliseconds | 44.931 | 43.602 | |
6a | CM-H P/T write | milliseconds | 27.048 | 26.271 | |
6b | CM-H P/T write alternate id | milliseconds | 38.520 | 37.115 | |
7 | Legacy Batch | events/second | 230.700 | 244.442 |