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 [EMAIL PROTECTED] 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?" ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
