반응형
/****************************************************************************************************************
-- Title : [PGS9.2] Parameter setup/tuning
-- Reference : postgresql.org, blog.naver.com/hdlee91, www.linxus.co.kr/darkill98, blog.naver.com/hdlee91
-- Key word : postgresql postgresql.conf parameter setting up setup set up performance 파라미터 설정 configure
set up tuning 튜닝
****************************************************************************************************************/
※ These parameters typed BOLD, are set like mentioning in advance.
--------------------------
-- Setting for MEMORY
-- Title : [PGS9.2] Parameter setup/tuning
-- Reference : postgresql.org, blog.naver.com/hdlee91, www.linxus.co.kr/darkill98, blog.naver.com/hdlee91
-- Key word : postgresql postgresql.conf parameter setting up setup set up performance 파라미터 설정 configure
set up tuning 튜닝
****************************************************************************************************************/
※ These parameters typed BOLD, are set like mentioning in advance.
--------------------------
-- Setting for MEMORY
-- 전체 80% 사용 권장(오이사님)
--------------------------
--------------------------
o shared_buffers (integer)
: Shered Memory Buffer size which is used by DBMS.
: Allocate a half or a quater of real memory size.
: Default 32MB is too small in comparison with latest h/w spec.
o wal_buffers
: there is no easy way to know getting a proper size of wal_buffers.
: recommend 1/32 of shared_buffers size.
: in 9.3, it's scheduled to provide a function which can check wal_buffers size.
ㅇ temp_buffers (integer)
: Maximum value which is used by every session.
: Default is 8MB.
ㅇ work_mem (integer)
: Memory size used by SORT or HAHS TABLE, etc.
: Default is 1MB.
: System for OLAP type is recommended 500M.
ㅇ maintenace_work (integer)
: Maximum memory size used by VACCUM, CREATE INDEX, ALTER TABLE ADD FOREIGN KEY etc.
: Default is 16MB.
: Recommend 32MB ~ 256MB.
o sort_mem
: sorting buffer size.
: ??
: Shered Memory Buffer size which is used by DBMS.
: Allocate a half or a quater of real memory size.
: Default 32MB is too small in comparison with latest h/w spec.
o wal_buffers
: there is no easy way to know getting a proper size of wal_buffers.
: recommend 1/32 of shared_buffers size.
: in 9.3, it's scheduled to provide a function which can check wal_buffers size.
ㅇ temp_buffers (integer)
: Maximum value which is used by every session.
: Default is 8MB.
ㅇ work_mem (integer)
: Memory size used by SORT or HAHS TABLE, etc.
: Default is 1MB.
: System for OLAP type is recommended 500M.
ㅇ maintenace_work (integer)
: Maximum memory size used by VACCUM, CREATE INDEX, ALTER TABLE ADD FOREIGN KEY etc.
: Default is 16MB.
: Recommend 32MB ~ 256MB.
o sort_mem
: sorting buffer size.
: ??
---------------------------
-- Setting for CHECKPOINT
---------------------------
o checkpoint_segments
: default value is 3. it means postgresql write 48MB(16MB X 3) transaction log and generate
checkpoint.
: when setting up as above, checkpoints are occuring too frequently.
: Recommend 64 ~ 128MB.
o checkpoint_timeout
: default value is 5 minutes(5m) but it's too short.
: recommend ??
-- Setting for CHECKPOINT
---------------------------
o checkpoint_segments
: default value is 3. it means postgresql write 48MB(16MB X 3) transaction log and generate
checkpoint.
: when setting up as above, checkpoints are occuring too frequently.
: Recommend 64 ~ 128MB.
o checkpoint_timeout
: default value is 5 minutes(5m) but it's too short.
: recommend ??
----------------------------
-- Setting for TRANSACTION
----------------------------
o Fsync
: default value is on.
: when on, disk writing occurs frequently and it's take some time.
: when off, transaction processing is fast but difficult to recovery.
---------------------------
-- Setting for CONNECTION
---------------------------
ㅇ listening_address (string)
: TCP/IP Address which is waiting connection from Client.
ㅇ port(integer)-- Setting for TRANSACTION
----------------------------
o Fsync
: default value is on.
: when on, disk writing occurs frequently and it's take some time.
: when off, transaction processing is fast but difficult to recovery.
---------------------------
-- Setting for CONNECTION
---------------------------
ㅇ listening_address (string)
: TCP/IP Address which is waiting connection from Client.
: TCP port which is waiting Connetion,
: Default is 5444.
ㅇ max_connections (integer)
: The number of Connection which is able to connect to database server at the same time.
: Default is 100.
: Recommend 256.
ㅇ superuser_reserved_connections(integer)
: The number of Connection(slot) reserved for superuser.
ㅇ unix_socket_directory (string)
: Set Unix-Domain socket directory.
: Default is /tmp.
--------------------------------------------
-- Setting for SECURITY and CERTIFICATION
--------------------------------------------
ㅇ authentication_timeout (integer)
: Maximum time until completion of client authentication.
ㅇ ssl (boolean)
: Set ssl connection.
ㅇ ssl_ciphers (string)
: Select ssl_chipher list.
ㅇ password_encryption (boolean)
: Define password encryption when use CREATE USER or ALTER USER command.
: Default is ON.
---------------------------------
-- Setting for KERNEL RESOURCE
---------------------------------
ㅇ max_files_per_process (integer)
: Maximum file number which subprocess of every server is opening
ㅇ shared_preload_libraries (string)
: Specify libraries which is preloaded on server starting,
------------------
-- Setting for LOG
------------------
ㅇ log_destination (string)
: Kind of log which is gonna logging.
: ex. stderr, syslog, eventlog etc.
ㅇ logging_collector (boolean)
: Transfer server messges in stderr, CSV-format.
ㅇ log_directory (string)
: Storage location of server log.
ㅇ log_filename (string)
: Designate log file name.
ㅇ log_rotation_age (integer)
: Log switch cycle.
: Unit is Minute.
ㅇ log_rotation_size (integer)
: Maximum value of log file size.
: Unit is KB.
ㅇ log_truncate_on_rotation (boolean)
: When cycling is occured in some time and existing file name is same, determine overwrite or not.
ㅇ
:
ㅇ
:
ㅇ
:
ㅇ
:
ㅇ
:
ㅇ
:
ㅇ
:
ㅇ
:
ㅇ
:
계속... EDB 문서에서...
반응형