RE: temp_file_limit parameter ignored?

Поиск
Список
Период
Сортировка
Искать
От
Erwin Fritz
Тема
RE: temp_file_limit parameter ignored?
Дата
Msg-id
9E6E27BCA0E8EE478089F158D73AF936A91F367A@Exch10-Mailbox.corp.gljpc.com
Ответ на
Список
Дерево обсуждения
temp_file_limit parameter ignored? Erwin Fritz <efritz@gljpc.com>
Re: temp_file_limit parameter ignored? Johannes Truschnigg <johannes@truschnigg.info>
RE: temp_file_limit parameter ignored? Erwin Fritz <efritz@gljpc.com>
Re: temp_file_limit parameter ignored? Tom Lane <tgl@sss.pgh.pa.us>
RE: temp_file_limit parameter ignored? Erwin Fritz <efritz@gljpc.com>
Re: temp_file_limit parameter ignored? Jerry Sievers <gsievers19@comcast.net>
Re: temp_file_limit parameter ignored? Jerry Sievers <gsievers19@comcast.net>
RE: temp_file_limit parameter ignored? Erwin Fritz <efritz@gljpc.com>
Re: temp_file_limit parameter ignored? Johannes Truschnigg <johannes@truschnigg.info>
RE: temp_file_limit parameter ignored? Erwin Fritz <efritz@gljpc.com>
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 privileged and confidential. If you have received this message in error, please notify the sender immediately and delete all copies.
-----------------------------

________________________________________
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  writes:
> Hmm. I did that, and the sourcefile and sourceline values are blank. I then ran "show config_file" and the result has the correct location of the file.

What does the "source" column say?

                        regards, tom lane
В списке pgsql-admin по дате отправления
От: Erwin Fritz
Дата:
От: David Steele
Дата:
FAQ