| 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: | Whole Thread | Raw Message | 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 |