From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jeremy Harris <jgh(at)wizmail(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Memory usage during sorting |
Date: | 2012-03-18 15:45:47 |
Message-ID: | 8727.1332085547@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Jeremy Harris <jgh(at)wizmail(dot)org> writes:
> On 2012-03-18 15:25, Tom Lane wrote:
>> Yeah, that was me, and it came out of actual user complaints ten or more
>> years back. (It's actually not 2X growth but more like 4X growth
>> according to the comments in logtape.c, though I no longer remember the
>> exact reasons why.) We knew when we put in the logtape logic that we
>> were trading off speed for space, and we accepted that.
> How about a runtime check of disk-free?
Not very workable, the foremost reason why not being that it assumes
that the current sort is the only thing consuming disk space. I'm not
sure there is any portable method of finding out how much disk space
is available, anyway. (Think user quotas and such before supposing
you know how to do that.)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2012-03-18 15:56:27 | Re: Memory usage during sorting |
Previous Message | Andrew Dunstan | 2012-03-18 15:33:44 | Re: Recent MinGW postgres builds with -O2 do not pass regression tests |