PostgreSQL配置文件--其他
2024-08-28 15:06:31
9 CLIENT CONNECTION DEFAULTS
9.1 Statement Behavior
9.1.1 search_path
字符型
默认：search_path = '"$user", public'
当以用户登录数据库时,默认先查找哪些数据库。
"$user"表示同用户名
9.1.2 default_tablespace
字符型
默认：default_tablespace = ''
默认tablespace, ''使用系统默认值
9.1.3 temp_tablespaces
字符型
默认：temp_tablespaces = ''
临时tablespaces列表，''表示使用系统默认值
a list of tablespace names, '' uses only default tablespace
9.1.4 defaulttransactionisolation
字符型
默认：default_transaction_isolation = 'read committed'
数据库的隔离级别有四种，分别是 Read uncommitte、Read committed、Repeatable read、Serializable。
9.1.5 其他
check_function_bodies = on
default_transaction_read_only = off
default_transaction_deferrable = off
session_replication_role = 'origin'
statement_timeout = 0 # in milliseconds, 0 is disabled
lock_timeout = 0 # in milliseconds, 0 is disabled
idle_in_transaction_session_timeout = 0 # in milliseconds, 0 is disabled
vacuum_freeze_min_age = 50000000
vacuum_freeze_table_age = 150000000
vacuum_multixact_freeze_min_age = 5000000
vacuum_multixact_freeze_table_age = 150000000
bytea_output = 'hex' # hex, escape
xmlbinary = 'base64'
xmloption = 'content'
gin_fuzzy_search_limit = 0
gin_pending_list_limit = 4MB
9.2 Locale and Formatting
datestyle = 'iso, mdy'
intervalstyle = 'postgres'
timezone = 'PRC'
timezone_abbreviations = 'Default' # Select the set of available time zone abbreviations. Currently, there are Default、Australia (historical usage)、India。You can create your own file in share/timezonesets/.
extra_float_digits = 0 # min -15, max 3
client_encoding = sql_ascii # actually, defaults to database encoding
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'en_US.UTF-8' # locale for system error message strings
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
# default configuration for text search
default_text_search_config = 'pg_catalog.english'
3、Other Defaults
dynamic_library_path = '$libdir'
local_preload_libraries = ''
session_preload_libraries = ''
10 LOCK MANAGEMENT
10.1 deadlock_timeout
数字型
默认： deadlock_timeout = 1s
在检查死锁前，等待锁的时间
deadlock检查机制执行的代价比较高，因此在符合较重、locK动作较多的系统里，可以适当地增大deadlock_timeout
10.2 其他
max_locks_per_transaction = 64 # min 10 (change requires restart)
max_pred_locks_per_transaction = 64 # min 10 (change requires restart)
max_pred_locks_per_relation = -2 # negative values mean (max_pred_locks_per_transaction / -max_pred_locks_per_relation) - 1
max_pred_locks_per_page = 2 # min 0
11 版本/平台兼容性 VERSION/PLATFORM COMPATIBILITY
11.1 以前的PostgreSQL版本 Previous PostgreSQL Versions
array_nulls = on
backslash_quote = safe_encoding # on, off, or safe_encoding
default_with_oids = off
escape_string_warning = on
lo_compat_privileges = off
operator_precedence_warning = off
quote_all_identifiers = off
standard_conforming_strings = on
synchronize_seqscans = on
11.2 Other Platforms and Clients
transform_null_equals = off
12 ERROR HANDLING
exit_on_error = off # terminate session on any error?
restart_after_crash = on # reinitialize after backend crash?
13 CONFIG FILE INCLUDES
include_dir = 'conf.d' # include files ending in '.conf' from directory 'conf.d'
include_if_exists = 'exists.conf' # include file only if it exists
include = 'special.conf' # include file最新文章
- Jmeter安装与环境部署
- Unity iOS混合开发界面切换思路
- 10.Pattern 和 Matcher
- React + Redux 入坑指南
- win8设置保护眼睛的颜色
- Druid Monitor监控JavaSE,杀cmd端口进程
- RSA Study
- 为 Github 创造 Integration
- 【转】C++多态性
- 清风注解-Swift程序设计语言:Point11～15
- Python 邮件发送
- Django web框架开发基础-django实现留言板功能
- es6常用语法学习笔记
- linux在线安装mysql
- pyCharm django 中新加app
- JAVAWEB 一一ibatis（框架)
- [深入浅出Cocoa]iOS网络编程之Socket
- [翻译] REMenu
- 【linux系列】vmware12pro安装centos7
- Django - rest - framework - 上