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.


                        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

Reply via email to