Re: using a lot of maintenance_work_mem - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: using a lot of maintenance_work_mem
Date
Msg-id 1297891452.7986.2.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: using a lot of maintenance_work_mem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: using a lot of maintenance_work_mem  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-hackers
On mån, 2011-02-14 at 10:11 -0500, Tom Lane wrote:
> But before expending time on that, I'd want to see some evidence that
> it's actually helpful for production situations.  I'm a bit dubious
> that you're going to gain much here.

If you want to build an index on a 500GB table and you have 1TB RAM,
then being able to use >>1GB maintenance_work_mem can only be good, no?




pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Usability tweaks for extension commands
Next
From: Robert Haas
Date:
Subject: Re: Add support for logging the current role