Re: maintenance_work_mem + create index

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: maintenance_work_mem + create index
Date: 2011-03-24 14:13:03
Message-ID: 20110324141303.GE4116@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Uwe,

* Uwe Bartels (uwe(dot)bartels(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Uwe Bartels 2011-03-24 14:40:33 Re: maintenance_work_mem + create index
Previous Message Uwe Bartels 2011-03-24 13:56:35 maintenance_work_mem + create index