Re: How to craft a query that uses memory?

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "'Holger(dot)Friedrich-Fa-Trivadis(at)it(dot)nrw(dot)de *EXTERN*'" <Holger(dot)Friedrich-Fa-Trivadis(at)it(dot)nrw(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to craft a query that uses memory?
Date: 2015-06-19 10:56:25
Message-ID: A737B7A37273E048B164557ADEF4A58B50F665D7@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Holger Friedrich wrote:
> So how do I craft a query that actually does use lots of memory?

You increase the parameter "work_mem".

You can do that globally in postgresql.conf or with SET for one session
or with SET LOCAL for one transaction.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gary Cowell 2015-06-19 11:15:22 Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4
Previous Message Holger.Friedrich-Fa-Trivadis 2015-06-19 10:42:20 How to craft a query that uses memory?