To check whether these settings are running, execute the following command. ALTER SYSTEM SET bgwriter_lru_maxpages = '1000' ĪLTER SYSTEM SET bgwriter_lru_multiplier = '4.0' ĪLTER SYSTEM SET random_page_cost = '2.0' ĪLTER SYSTEM SET cpu_tuple_cost = '0.03' ĪLTER SYSTEM SET log_autovacuum_min_duration = '0' ĪLTER SYSTEM SET autovacuum_max_workers = '5' ĪLTER SYSTEM SET autovacuum_vacuum_cost_delay = '10ms' Įnter # \q to quit the PostgreSQL database. 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 Create a /etc//CentOS-Media. loop-mount a DVD iso image as /media/cdrom, set the baseurl of one repository to file:///media/cdrom and tell yum to ignore the other repos. Initialize the database and enable automatic start. 2 Answers Sorted by: 2 I think you could treat the first CentOS installation DVD as a repository, i.e. 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 |