From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Jim Nasby <decibel(at)decibel(dot)org> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [COMMITTERS] pgsql: Teach tuplesort.c about "top N" sorting, in which only the first |
Date: | 2007-05-09 16:01:52 |
Message-ID: | 20070509160152.GC14957@svr2.hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
On Wed, May 09, 2007 at 10:55:12AM -0500, Jim Nasby wrote:
> On May 8, 2007, at 2:24 PM, Magnus Hagander wrote:
> >Speaking of which, it might be interesting to actually show these
> >values
> >in the stats collector. I was thinking three cols for each database
> >(probably the best level?) that counts each of those three
> >counters. If
> >you have a lot of sorts (percentage-wise) spilling to disk, it is
> >often
> >something you want to investigate, so exposing it that way seems
> >like a
> >good thing.
>
> What 3 columns? In-memory sorts, on-disk sorts, and on-disk size?
> (Sum of how much spilled to disk).
I was thinking in-mem sorts, on-disk sorts, limited-by-LIMIT sorts (that
would be the new feature..)
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2007-05-09 16:17:23 | Re: Re: [COMMITTERS] psqlodbc - psqlodbc: Put Autotools-generated files into subdirectory |
Previous Message | Jim Nasby | 2007-05-09 15:55:12 | Re: [COMMITTERS] pgsql: Teach tuplesort.c about "top N" sorting, in which only the first |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2007-05-09 16:17:23 | Re: Re: [COMMITTERS] psqlodbc - psqlodbc: Put Autotools-generated files into subdirectory |
Previous Message | Jim Nasby | 2007-05-09 15:55:12 | Re: [COMMITTERS] pgsql: Teach tuplesort.c about "top N" sorting, in which only the first |