Bug 1958014
| Summary: | tuned-profiles-postgresql does not exist in RHEL8 repo | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Linux 8 | Reporter: | masanari iida <masanari.iida> |
| Component: | releng | Assignee: | Jaroslav Škarvada <jskarvad> |
| releng sub component: | RHELCMP | QA Contact: | Robin Hack <rhack> |
| Status: | CLOSED ERRATA | Docs Contact: | |
| Severity: | low | ||
| Priority: | unspecified | CC: | jeder, jskarvad, jvaldez, jzerdik, lkuprova, rhack |
| Version: | 8.3 | Keywords: | TestCaseNeeded, Triaged |
| Target Milestone: | beta | Flags: | pm-rhel:
mirror+
|
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | tuned-2.19.0-0.1.rc1.el8 | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2022-11-08 10:52:37 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
|
Description
masanari iida
2021-05-07 02:31:48 UTC
Check the RHEL8.4(beta) iso, There is no tuned-profile-postgresql RPM package. # ls -l tune* -r--r--r-- 291 root root 310692 Feb 26 03:50 tuned-2.15.0-2.el8.noarch.rpm -r--r--r-- 291 root root 36820 Feb 26 03:51 tuned-profiles-atomic-2.15.0-2.el8.noarch.rpm -r--r--r-- 291 root root 40172 Feb 26 03:51 tuned-profiles-compat-2.15.0-2.el8.noarch.rpm -r--r--r-- 291 root root 39904 Feb 26 03:51 tuned-profiles-cpu-partitioning-2.15.0-2.el8.noarch.rpm -r--r--r-- 291 root root 36288 Feb 26 03:51 tuned-profiles-mssql-2.15.0-2.el8.noarch.rpm -r--r--r-- 291 root root 36596 Feb 26 03:51 tuned-profiles-oracle-2.15.0-2.el8.noarch.rpm # ls -l tune* -r--r--r-- 291 root root 61560 Feb 26 03:51 tuned-gtk-2.15.0-2.el8.noarch.rpm -r--r--r-- 291 root root 46732 Feb 26 03:51 tuned-utils-2.15.0-2.el8.noarch.rpm -r--r--r-- 291 root root 51836 Feb 26 03:51 tuned-utils-systemtap-2.15.0-2.el8.noarch.rpm Thanks for the report. It's probably inconsistency in the documentation. The postgresql profile is in the TuneD upstream, but we haven't shipped it in RHEL yet, because the profile hasn't been approved by our performance team. I will try to move it forward and introduce the profile into RHEL. Hi, thanks for letting us know. I will remove the profile description from this docs section ASAP and get it back in when the postgresql profile is shipped in RHEL. I've removed the description of the postgresql profile: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html/monitoring_and_managing_system_status_and_performance/getting-started-with-tuned_monitoring-and-managing-system-status-and-performance#tuned-profiles-distributed-with-rhel_getting-started-with-tuned We are going to ship this profile / package in RHEL-8. Sanjay Rao <srao> tested the profile and provided the following results: >I finished my testing on different storage types that were available. I found that we saw a 7% improvement in performance with the postgres profile with very high user count on Fibrechannel storage. See chart below. I did 2 runs with each profile to validate the results. > >2500WH Testing for Postgres profile 200 500 >4.18.0-318.el8-20P-256Gmem-TP 1425657 784348 >4.18.0-318.el8-20P-256Gmem-TP 1419516 782804 >4.18.0-318.el8-20P-256Gmem-Postgres 1438529 833350 >4.18.0-318.el8-20P-256Gmem-Postgres 1440257 841219 > >As we suspected, the background_dirty_bytes setting helps in systems with legacy storage, that too with very high memory activity. Flushing dirty blocks in the backgrounds helps free up memory and ekes out some more transactions. > >So to summarize, the postgres profile does not help with fast storage but does not have any negative implications but it definitely helps in legacy storage. I will see if we get a chance to test this on virtualization and share the results. The HammerDB (https://github.com/TPC-Council/HammerDB) was used for testing. Moving to relengs. TLDR: we need the tuned-profiles-postgresql subpackage to be shipped in the RHEL-8.5 and newer erratas (including RHEL-9), e.g.: https://errata.devel.redhat.com/advisory/78559/builds The subpackage should be in the BaseOS-8.5.0.GA, currently it is not in Product Listings. Justification is in the comment 6, better performance means better customer experience, thus we definitely want to ship and support it in RHEL. Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory (tuned bug fix and enhancement update), and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2022:7747 |