[YSQL] Open file descriptors needs to be increased on Rocky Linux 8

[sonalsagarwal]

Jira Link: DB-13990

Description

The current open file limit for the Rocky Linux AMI ami-0fb522a0137ed95d8 is set to 1024, but it should be configured to "unlimited."
In Perf tests, we have noticed failures on 16-core instances when attempting to create and load data into a large number of tables (around 6,500).
Error:
F20241107 10:45:11 ../../src/yb/consensus/log.cc:920] Check failed: _s.ok() Bad status: IO error (yb/consensus/log_index.cc:181): Couldn't open index chunk: open: Too many open files (system error 24)
Current limit :

[rocky@ip-172-151-28-250 ~]$ ulimit -n
1024

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.