Re: sort_mem param of postgresql.conf

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgSQL - General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: sort_mem param of postgresql.conf
Date: 2008-11-12 14:51:34
Message-ID: 2f4958ff0811120651y2ce2ca82v7b6a88776f004b80@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 of a memory to do it ;)

thanks anyway.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-11-12 15:01:04 Re: sort_mem param of postgresql.conf
Previous Message Tom Lane 2008-11-12 14:47:47 Re: still gin index creation takes forever