stats_temp_directory
A system parameter determining the directory for temporary statistics data
stats_temp_directory
is a configuration parameter determining the location of the directory for storing temporary statistics data in.
stats_temp_directory
was added in PostgreSQL 8.4 and removed in PostgreSQL 15.
Usage
By default, temporary statistics data is stored in the pg_stat_tmp
directory within the data directory. However it may be desirable to use a custom location such as a RAM-based disk for better performance; this can be achieved by setting stats_temp_directory
.
From PostgreSQL 15, temporary statistics are stored in memory by default so stats_temp_directory
will no longer be available.
Default value
The default value for stats_temp_directory
is: pg_stat_tmp
.
Change history
- PostgreSQL 15
- removed (commit 6f0cf878)
- PostgreSQL 8.4
- added (commit 5b8eb2b4)
References
- PostgreSQL 14 documentation: stats_temp_directory
Categories
See also
pg_stat_tmp