Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group