Re: changing sort_mem on the fly?

On Sun, Jan 30, 2005 at 08:50:49PM +1100, Neil Conway wrote:
> Jim C. Nasby wrote:
> >I'd really like to see an improvement in how sort_mem/work_mem is
> >handled.
>
> So would I :) (I think it's well known that the current system is not
> optimal.)
>
> Do you have any thoughts on how to improve it?

See http://archives.postgresql.org/pgsql-general/2003-06/msg01072.php
and http://archives.postgresql.org/pgsql-general/2003-06/msg01089.php

There could certainly be better ways than what I proposed, too. It might
be worth investigating how the 'big 3' handle it, though some of what
they do might be patented.
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"