On 2020-06-06 06:57, Thomas Munro wrote:
We're carrying a bunch of obsolete and in one case insecure advice on kernel settings. Here's an attempt to clean some of that up.
These changes seem sensible to me.
HP-UX: * Drop advice for v10. 11.x came out 23 years ago.
We still have a version 10 in the build farm. :)
It's a bit inconsistent that we bother to explain the SysV shmem sysctls on some systems but not others, just because once upon a time it was necessary to tweak them on some systems and not others due to defaults. You shouldn't need that anywhere now IIUC, unless you run a lot of clusters or use shared_memory_type=sysv. I'm not proposing to add it where it's missing, as I don't have the information and I doubt it's really useful anyway; you can find that stuff elsewhere if you really need it.
When this was a serious hurdle on the olden days, we added as much information as possible. I agree we can trim it now or let it age out.
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services