Postgres Pro
Downloads
Home   >   mailing lists

Re: How to make PG use work_mem? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to make PG use work_mem?
Date
Msg-id 12942.1394550222@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to make PG use work_mem?  (Torsten Förtsch <torsten.foertsch@gmx.net>)
Responses Re: How to make PG use work_mem?  (Torsten Förtsch <torsten.foertsch@gmx.net>)
List pgsql-general
Tree view 
=?ISO-8859-1?Q?Torsten_F=F6rtsch?= <torsten.foertsch@gmx.net> writes:
> On 11/03/14 14:36, Tom Lane wrote:
>> Perhaps you fat-fingered the SET somehow?

> I just repeated it:

[ thinks for awhile... ]  Oh, I know what's happening: your sort is so
large that it's being constrained by the MaxAllocSize limit on the tuple
pointer array.  This has been fixed in HEAD, but it's not yet in any
shipping release.  According to the log entry for commit
263865a48973767ce8ed7b7788059a38a24a9f37, the previous limit on the number
of tuples that could be sorted in memory was INT_MAX/48 or about 44
million; I've not done the arithmetic to check that, but it seems about
right seeing that you're having trouble with 75 million.

            regards, tom lane

pgsql-general by date:

Previous
From: nill
Date:
Subject: Re: Extracting data from the view to retrieve the foreign key is not declared
Next
From: Torsten Förtsch
Date:
Subject: Re: How to make PG use work_mem?