Re: maintenance_work_mem + create index - Mailing list pgsql-performance

From Stephen Frost
Subject Re: maintenance_work_mem + create index
Date
Msg-id 20110324141303.GE4116@tamriel.snowman.net
Whole thread Raw
In response to maintenance_work_mem + create index  (Uwe Bartels <uwe.bartels@gmail.com>)
Responses Re: maintenance_work_mem + create index
List pgsql-performance
Uwe,

* Uwe Bartels (uwe.bartels@gmail.com) wrote:
> So I checked this again and raised afterwards maintenance_work_mem step by
> step up 64GB.
> I logged in via psql, run the following statements
> set maintenance_work_mem = '64GB';

I believe maintenance_work_mem suffers from the same problem that
work_mem has, specifically that PG still won't allocate more than
1GB of memory for any single operation.

    Thanks,

        Stephen

Attachment

pgsql-performance by date:

Previous
From: Uwe Bartels
Date:
Subject: maintenance_work_mem + create index
Next
From: Uwe Bartels
Date:
Subject: Re: maintenance_work_mem + create index