Re: Open items

On Thu, Jun 30, 2005 at 10:11:56AM -0400, Rod Taylor wrote:
> On Thu, 2005-06-30 at 23:02 +0900, Satoshi Nagayasu wrote:
> > > The TODO item is about counting all temporary files, not sorts in
> > > particular.  Or at least that's what I thought it meant.
> > 
> > If the DBA have to improve the performance,
> > DBA will need to know about:
> > 
> >   - Which SQL generate a disk sort?
> 
> Good point. An EXPLAIN ANALYZE note about the disk usage for the sort
> would be really nice.

Even nicer would be a way to log queries that generate on-disk sorts.
-- 
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?"