Re: temp_file_limit parameter ignored?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Jerry Sievers <gsievers19@xxxxxxxxxxx> writes:

> Erwin Fritz <efritz@xxxxxxxxx> writes:
>
>> 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
>
> ^^^^^
>
> This means someone/thing said...
>
> ALTER DATABASE $foodb SET temp_file_limit to '$whatever';
>
> See psql \drds.
>
> Just do an explicit override in your own job prior to the code that
> errors out due to resource shortfall.
>
> SET temp_file_limit to -1;

oops!  Pardon me.  only superuser can frob that setting so this advice I
gave immediately above might not help you.

>
> HTH
>
>
>> 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@xxxxxxxxxxxxx]
>> Sent: August 20, 2018 09:26
>> To: Erwin Fritz
>> Cc: Johannes Truschnigg; pgsql-admin@xxxxxxxxxxxxxx
>> Subject: Re: temp_file_limit parameter ignored?
>>
>> Erwin Fritz <efritz@xxxxxxxxx> 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
>>
>>

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@xxxxxxxxxxx
p: 312.241.7800




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux