RE: temp_file_limit parameter ignored?
От | Erwin Fritz |
---|---|
Тема | RE: temp_file_limit parameter ignored? |
Дата | |
Msg-id | 9E6E27BCA0E8EE478089F158D73AF936A91F367A@Exch10-Mailbox.corp.gljpc.com обсуждение исходный текст |
Ответ на | Re: temp_file_limit parameter ignored? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: temp_file_limit parameter ignored?
|
Список | pgsql-admin |
Here's the output: select * from pg_settings where name = 'temp_file_limit'; -[ RECORD 1 ]---+------------------------------------------------------------------- name | temp_file_limit setting | 4194304 unit | kB category | Resource Usage / Disk short_desc | Limits the total size of all temporary files used by each session. extra_desc | -1 means no limit. context | superuser vartype | integer source | database min_val | -1 max_val | 2147483647 enumvals | boot_val | -1 reset_val | 4194304 sourcefile | sourceline | pending_restart | f ----------------------------- This message is intended only for the recipient(s) to which it is addressed and may contain information that is privilegedand confidential. If you have received this message in error, please notify the sender immediately and delete allcopies. ----------------------------- ________________________________________ From: Tom Lane [tgl@sss.pgh.pa.us] Sent: August 20, 2018 09:26 To: Erwin Fritz Cc: Johannes Truschnigg; pgsql-admin@postgresql.org Subject: Re: temp_file_limit parameter ignored? Erwin Fritz <efritz@gljpc.com> writes: > Hmm. I did that, and the sourcefile and sourceline values are blank. I then ran "show config_file" and the result has thecorrect location of the file. What does the "source" column say? regards, tom lane
Вложения
В списке pgsql-admin по дате отправления: