PostgreSQL: Connection and verification Configuration

Listen_addresses = 'localhost'Non-dynamic-- The IP address of the NIC that PostgreSQL listens to. By default, only the IP address is local. You can configure multiple IP addresses. Separate them with commas. "*" Indicates the IP addresses of all NICs.

Port = 5432Non-dynamic-- Port

Max_connections = 100Non-dynamic-- Maximum number of server connections

Superuser_reserved_connections = 3Non-dynamic-- The number of dedicated connections retained by the Administrator. Common users cannot use these connections. Cannot be greater than max_connections

 

Authentication_timeout = 60 s -- logon verification timeout

SSL = falseNon-dynamic-- Whether to use SSL connection

Password_encryption = true -- if you use create user or alter user to manage users, whether the PostgreSQL server automatically encrypts the passwords if the user is not encrypted or not.

 

Shared_buffers = 32 mNon-dynamic-- Shared cache. Very important performance parameters. The minimum value is (128 K, 16 K * max_connections)

Max_prepared_transactions = 5Non-dynamic-- Maximum parallel prepared transactions. If the value is 0, prepared transactions are not allowed. The maximum number of transactions that meet the requirements of max_connections is the same.

Temp_buffers = 8 mAdjustable sessions-- Temporary (table) cache size available for each session

Work_mem = 1 mAdjustable sessions-- Specifies the memory size that PostgreSQL can use when internal sorting, connection, group, and so on. If this value is exceeded, temporary disk files will be used.. The actual memory used is multiplied by the number of concurrent operations of this type.

Maintenance_work_men = 16 m-- Maintain the memory size that can be used by statements such as vacuum and create index. The actual memory used is multiplied by the number of concurrent operations of this type.

 

Fsync = on -- (physical data) logs must be synchronized to the disk-Log Data Security with the highest performance loss.

Synchronous_commit = onAdjustable sessions-- (Logical transaction data) the log must be synchronized to the disk. If it is set to on, fsync will be called immediately, which is equivalent to setting fsync = on

Full_page_writes = on -- write the entire page

Wal_buffers = 64 K

Wal_writer_delay = 200 ms -- the period during which Wal logs are written to the disk from wal_buffer.

Commit_delay = 0 Ms -- latency of writing data to the disk after the transaction log commit. This setting is valid only when commit_sibings (Multiple Queuing transactions in parallel) exist within the latency.

Commit_siblings = 5