sort_mem param of postgresql.conf

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

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 .

--
GJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2008-11-12 14:43:42 Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)
Previous Message Teodor Sigaev 2008-11-12 14:31:06 Re: still gin index creation takes forever