Re: query memory consumption - Mailing list pgsql-performance

From Alan McKay
Subject Re: query memory consumption
Date
Msg-id 844129e80909220546l230dc827we45d908960280d39@mail.gmail.com
Whole thread Raw
In response to Re: query memory consumption  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Responses Re: query memory consumption  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance
> Best practice to avoid that, is to bump the work_mem temporarily
> before the query, and than lower it again, lowers the chance of memory
> exhaustion.

Interesting - I can do that dynamically?


--
“Don't eat anything you've ever seen advertised on TV”
         - Michael Pollan, author of "In Defense of Food"

pgsql-performance by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: query memory consumption
Next
From: Greg Spiegelberg
Date:
Subject: Re: session servers in ram