On Thu, Nov 13, 2008 at 7:42 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
>
>
> Other alternatives worth reading about:
>RESET work_mem
>SET LOCAL work_mem
>
nice , thanks :)
--
GJ
Sam Mason <[EMAIL PROTECTED]> writes:
> On Thu, Nov 13, 2008 at 02:59:34PM +, Grzegorz Jaaakiewicz wrote:
>> so how do I change it back to default (without knowing what the previous val
>> was). I suppose having it in a transaction won't do :P
> If by "default" you mean whatever was in the con
On Thu, Nov 13, 2008 at 02:59:34PM +, Grzegorz Jaaakiewicz wrote:
> On Wed, Nov 12, 2008 at 11:08 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> > Generally, if it's only a report or two that
> > need a lot more working memory for sorts, you can do this at the beginning
> > of them instead:
> >
>
2008/11/13 Scott Marlowe <[EMAIL PROTECTED]>:
> On Thu, Nov 13, 2008 at 7:59 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>
> wrote:
>>
>>
>> On Wed, Nov 12, 2008 at 11:08 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
>>>
>>> Be advised that the work_mem setting (and its deprecated alias sort_mem)
>>> ar
On Thu, Nov 13, 2008 at 7:59 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote:
>
>
> On Wed, Nov 12, 2008 at 11:08 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
>>
>> Be advised that the work_mem setting (and its deprecated alias sort_mem)
>> are on a per-client basis. So if you have a bunch of peopl
On Wed, Nov 12, 2008 at 11:08 PM, Greg Smith <[EMAIL PROTECTED]> wrote:
> Be advised that the work_mem setting (and its deprecated alias sort_mem)
> are on a per-client basis. So if you have a bunch of people running reports
> with that setting, you might discover your server running out of memor
On Wed, 12 Nov 2008, Grzegorz Ja?~[kiewicz wrote:
that's on 8.3, by default there was no sort_mem , I hadded it , changed it
to 512MB and all of the sudent everything started to fly - wherever it
required hudge ammounts of memory for queries. The queries are reports, so
they basicaly join few ta
On Wed, Nov 12, 2008 at 3:01 PM, Alvaro Herrera
<[EMAIL PROTECTED]>wrote:
>
>
> sort_mem is just a convenience alias for work_mem.
>
> point taken
GJ
Grzegorz Jaśkiewicz escribió:
> that's on 8.3, by default there was no sort_mem , I hadded it , changed it
> to 512MB and all of the sudent everything started to fly
sort_mem is just a convenience alias for work_mem.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
that's on 8.3, by default there was no sort_mem , I hadded it , changed it
to 512MB and all of the sudent everything started to fly - wherever it
required hudge ammounts of memory for queries. The queries are reports, so
they basicaly join few tables, and dump all ofthat content - so it takes a
bit
On Wed, Nov 12, 2008 at 7:36 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote:
> Hey folks,
>
> Anyone knows why the "sort_mem" parametr isn't by default in postgresql.conf
> file ? I had no idea it existed before, and we had some hudge queries
> running 1-2 minutes here, doing all sorts on disc,
11 matches
Mail list logo
