Re: 2GB limit for temp_file_limit on 32bit platform

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 2GB limit for temp_file_limit on 32bit platform
Date: 2012-07-20 00:02:42
Message-ID: 19289.1342742562@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Janes 2012-07-20 00:05:36 pgbench -i order of vacuum
Previous Message Tom Lane 2012-07-19 23:40:02 Re: b-tree index search algorithms