From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Grzegorz Jaśkiewicz <gryzman(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:45:40 |
Message-ID: | dcc563d10811120645m6465e07g48924d4eec95b93@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Nov 12, 2008 at 7:36 AM, Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> 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, adding sort_mem = 512MB
> to config shortened that to 20s. These are run only ocasionaly, so the
> memory won't be always used - but helps in these few cases .
sort_mem is right there. If you're running an older version of pgql.
I think it turned into work_mem around 8.0 or 8.1
Are you trying to use a postgresql.conf from an older version of pgsql
with a newer version of pgsql?
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-11-12 14:47:47 | Re: still gin index creation takes forever |
Previous Message | Sergey Konoplev | 2008-11-12 14:43:42 | Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case) |