Re: 2GB limit for temp_file_limit on 32bit platform - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 2GB limit for temp_file_limit on 32bit platform
Date
Msg-id 19289.1342742562@sss.pgh.pa.us
Whole thread Raw
In response to 2GB limit for temp_file_limit on 32bit platform  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: 2GB limit for temp_file_limit on 32bit platform
Re: 2GB limit for temp_file_limit on 32bit platform
List pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> I did a backport of temp_file_limit feature to 9.1, but when we tested
> this patch, we found very restristrictive limit to 2GB.

> 2GB is nonsense, because this is session limit of temp files, and
> these files should be longer than 2GB.

This claim is nonsense.  The variable's value is measured in KB, so the
effective limit is actually 2TB not 2GB.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: b-tree index search algorithms
Next
From: Jeff Janes
Date:
Subject: pgbench -i order of vacuum