| From: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Fuhr <mike(at)fuhr(dot)org>, Lonni J Friedman <netllama(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: changing sort_mem on the fly? |
| Date: | 2005-01-30 10:19:06 |
| Message-ID: | 20050130101906.GK64304@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)decibel(dot)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?"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tzahi Fadida | 2005-01-30 11:56:55 | Re: Pinning buffers for long times like outer joins might do. |
| Previous Message | Neil Conway | 2005-01-30 09:50:49 | Re: changing sort_mem on the fly? |