Adjust citus memory configuration

[xin-hedera]

Description:

This PR several citus memory configuration

• Increase citus worker patroni container memory limit to 40GB
• Reduce work_mem to 12MB
• Reduce coordinator shared_buffers to 7GB
• Set priority class to critical

Related issue(s):

Related to #9355

Notes for reviewer:

CRD reference: https://stackgres.io/doc/1.11/reference/crd/sgshardedcluster/#sgshardedclusterspeccoordinatorpodsscheduling

same for workers

Checklist

• [ ] Documented (Code comments, README, etc.)
• [x] Tested (unit, integration, etc.)

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 92.55%. Comparing base (b2349db) to head (ede5fb3). Report is 1 commits behind head on main.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## main #9384 +/- ## ========================================= Coverage 92.55% 92.55% Complexity 7039 7039 ========================================= Files 912 912 Lines 29760 29760 Branches 3760 3760 ========================================= + Hits 27544 27545 +1 Misses 1445 1445 + Partials 771 770 -1 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud