On Wed, Nov 12, 2008 at 7:36 AM, Grzegorz Jaśkiewicz <gryzman@xxxxxxxxx> 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 pgsqlwith a newer version of pgsql? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
