Greg Stark <[EMAIL PROTECTED]> writes: > Dirk Lutzebaeck <[EMAIL PROTECTED]> writes: >> Can some please explain why the temp file is so huge? I understand >> there are a lot of rows.
> Well that I can't explain. 22k rows of width 1361 doesn't sound so big to me > either. It was 700k rows to sort, not 22k. The Unique/Limit superstructure only demanded 22k rows out from the sort, but we still had to sort 'em all to figure out which ones were the first 22k. > The temporary table does need to store three copies of the records at > a given time, but still it sounds like an awful lot. Huh? regards, tom lane ---------------------------(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