Re: maintenance_work_mem memory constraint? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: maintenance_work_mem memory constraint?
Date
Msg-id 23458.1196100134@sss.pgh.pa.us
Whole thread Raw
In response to maintenance_work_mem memory constraint?  (Bernd Helmle <mailings@oopsware.de>)
Responses Re: maintenance_work_mem memory constraint?  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
Bernd Helmle <mailings@oopsware.de> writes:
> ... But isn't it worth to special case the 
> code in grow_memtuples() (and maybe other places where sort is likely to 
> use more RAM), so that we can remove this constraint on 64-Bit systems with 
> many RAM built in? Or am I missing something very important?.

AFAICS this patch can increase the number of sortable tuples by at most 2X
(less one).  That doesn't seem worth getting very worked up about ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.3devel slower than 8.2 under read-only load
Next
From:
Date:
Subject: Re: Replacement Selection