Postgres Pro
Downloads
Home   >   mailing lists

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  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Re: 2GB limit for temp_file_limit on 32bit platform  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
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