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. -- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly