类型: | string |
默认: | pg_stat_tmp |
上下文: | sighup |
重新开始: | false |
设置存储临时统计数据的目录。这可以是一个相对于数据目录的路径或一个绝对路径。默认值是pg_stat_tmp。在一个基于 RAM 的文件系统上指明这个参数将降低物理 I/O 需求,并且提高性能。这个参数只能在postgresql.conf文件中或在服务器命令行上设置。
建议 [EN]
Useful for extremely high-volume databases; the stats temp directory could be set to a RAMdisk or other high-speed resource (at the cost of potentially losing some stats) as this file gets updated hundreds of times per second.
在 StackOverflow
- How to activate Postgresql statistics collector?
- Validate database output using chef inspec
- Postgres highload. 20000 requests per min causes resource request timed out
- Postgres process shows 100% CPU but actual usage is 6%, resulting in slow query response
- Postgres autovacuum fails to start due to misconfiguration
在 pgsql-hackers
- Re: Expand the use of check_canonical_path() for more GUCs
- Re: shared-memory based stats collector
- Re: Postgresql13_beta1 (could not rename temporary statistics file) Windows 64bits
- Creating a function for exposing memory usage of backend process
- Re: Creating a function for exposing memory usage of backend process