Re: [GENERAL] temporary memory configuration

2008-11-05 Thread Scott Marlowe
On Wed, Nov 5, 2008 at 8:09 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote: > hey folks, > > so suppose I have a query that in explain analyze > > Sort Method: external merge Disk: 218080kB > > What param should I set to high up, to end up with that sort in memory, and work_mem > also - will t

[GENERAL] temporary memory configuration

2008-11-05 Thread Grzegorz Jaśkiewicz
hey folks, so suppose I have a query that in explain analyze Sort Method: external merge Disk: 218080kB What param should I set to high up, to end up with that sort in memory, and also - will that memory will always be allocated per connection, (I am bit worried that having say 320MB of temporary