Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Postgres database flags default values are conflicting

rr1000
New Member

Several flags have conflicting "default" values.
For example log_temp_files at :https://cloud.google.com/sql/docs/postgres/flags

log_temp_filesinteger
0 ... 2147483647 KB, or -1 to disable
The default is 0.


If you go to the link for the flag at: https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-TEMP-FILES

The docs state:
log_temp_files (integer) 

Controls logging of temporary file names and sizes. Temporary files can be created for sorts, hashes, and temporary query results. If enabled by this setting, a log entry is emitted for each temporary file, with the file size specified in bytes, when it is deleted. A value of zero logs all temporary file information, while positive values log only files whose size is greater than or equal to the specified amount of data. If this value is specified without units, it is taken as kilobytes. The default setting is -1, which disables such logging. Only superusers and users with the appropriate SET privilege can change this setting.

So when using google_sql_database_instance what is the correct default value?

0 0 29
0 REPLIES 0