Postgres Pro
Downloads
Home   >   mailing lists

Re: How to craft a query that uses memory? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: How to craft a query that uses memory?
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50F665D7@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to How to craft a query that uses memory?  (<Holger.Friedrich-Fa-Trivadis@it.nrw.de>)
Responses Re: How to craft a query that uses memory?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From:
Date:
Subject: How to craft a query that uses memory?
Next
From: Gary Cowell
Date:
Subject: Transaction abort difference between psql, isql, ODBC and JDBC pgsql 8.4