PostgreSQL configuration - Revision history

Chinzo at 19:02, 6 November 2018

2018-11-06T19:02:23Z

← Older revision		Revision as of 19:02, 6 November 2018
Line 1:		Line 1:
	=='''How to tune PostgreSQL config file?'''==		=='''How to tune PostgreSQL config file?'''==

			Written by Chinzorig Dandarchuluun (Sep. 19, 2018).


	To install pgtune by using below code		To install pgtune by using below code

2018-09-19T18:23:27Z

How to tune PostgreSQL config file?

← Older revision		Revision as of 18:23, 19 September 2018
Line 1:		Line 1:
	=='''How to tune PostgreSQL config file?'''==		=='''How to tune PostgreSQL config file?'''==

	~~First you need~~ install pgtune by using below code		To install pgtune by using below code

	sudo yum install pgtune		sudo yum install pgtune

2018-09-19T18:22:42Z

← Older revision		Revision as of 18:22, 19 September 2018
Line 22:		Line 22:
	* -M or –memory: Use this parameter to specify total system memory. If not specified, pgtune will attempt to detect memory size.		* -M or –memory: Use this parameter to specify total system memory. If not specified, pgtune will attempt to detect memory size.

	* -T or –type : Specifies database type. Valid options are:DW, OLTP, Web, Mixed, Desktop		* -T or –type : Specifies database type. Valid options are: DW, OLTP, Web, Mixed, Desktop

	* -c or –connections: Specifies number of maximum connections expected. If not specified, it depends on database type.		* -c or –connections: Specifies number of maximum connections expected. If not specified, it depends on database type.

2018-09-19T18:20:45Z

← Older revision		Revision as of 18:20, 19 September 2018
Line 44:		Line 44:

	service postgresql-9.2 restart		service postgresql-9.2 restart


	~~https://www.tivix.com/blog/postgresql-no-effort-config-optimization~~

2018-09-19T18:19:30Z

← Older revision	Revision as of 18:19, 19 September 2018
Line 1:	Line 1:
		=='''How to tune PostgreSQL config file?'''==

		First you need install pgtune by using below code

		sudo yum install pgtune

		Go to the PostgreSQL data folder

		cd /var/lib/pgsql/9.2/data

		The command will output new config file with settings roughly optimized for the server’s hardware.

		pgtune -i postgresql.conf -o postgresql.conf.pgtune -T DW -c 1000

		'''PG Tune Options'''
		----

		* -i or –input-config : Specifies the current postgresql.conf file.

		* -o or –input-config : Specifies the file name for the new postgresql.conf file.

		* -M or –memory: Use this parameter to specify total system memory. If not specified, pgtune will attempt to detect memory size.

		* -T or –type : Specifies database type. Valid options are:DW, OLTP, Web, Mixed, Desktop

		* -c or –connections: Specifies number of maximum connections expected. If not specified, it depends on database type.

		* -D or –debug : Enables debugging mode.

		* -S or –settings: Directory where settings data files are located at.Defaults to the directory where the script is being run from. The RPM package includes a patch to use the correct location these files were installed into.

		----


		Backup the current config file

		sudo mv postgresql.conf postgresql.conf.backup

		And then setup new config file

		sudo mv postgresql.conf.pgtune postgresql.conf

		Restart the server

		service postgresql-9.2 restart


		https://www.tivix.com/blog/postgresql-no-effort-config-optimization

2018-08-17T13:44:28Z

Blanked the page

2018-08-17T13:43:57Z

Created page with "test"

New page

test