![]() ![]() sudo -u postgresql psqlĪLTER SYSTEM SET max_connections = '100' ĪLTER SYSTEM SET effective_cache_size = '12GB' ĪLTER SYSTEM SET maintenance_work_mem = '1GB' ĪLTER SYSTEM SET checkpoint_completion_target = '0.9' ĪLTER SYSTEM SET default_statistics_target = '100' ĪLTER SYSTEM SET effective_io_concurrency = '2' ĪLTER SYSTEM SET max_worker_processes = '8' ĪLTER SYSTEM SET max_parallel_workers_per_gather = '4' ĪLTER SYSTEM SET max_parallel_workers = '8' ĪLTER SYSTEM SET max_parallel_maintenance_workers = '4' Īdd the following settings to perform autovacuum. The configuration for PostgreSQL is calculated based on the provided hardware configuration.Ĭonnect to the PostgreSQL database. Select type of hard drive which PostgreSQL use as storage from the Data Storage list.Ĭlick Generate and go to the ALTER SYSTEM tab. Select 100 from the Number of Connections list. Select Mixed type of applications from the DB Type list.įor Total Memory (RAM) and Number of CPUs see Hardware requirements.įor the recommendations, see PostgreSQL recommendations. Go to PGTune and provide basic information about the hardware configuration. sudo /usr/pgsql-13/bin/postgresql-13-setup initdb Initialize the database and enable automatic start. Select RedHat Enterprise Linux 7 platform.To install PostgreSQL on RedHat Enterprise Linux 7 The Red Hat family of distributions includes: BMC recommends installing PostgreSQL 13 on Linux. Some distributions such as Red-Hat Family, Debian, Ubuntu, Suze and OpenSuze are available. ![]() BCM recommends installing PostgreSQL version 13 which faster than the older versions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |