Horton

Re: Sort and index

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Jim C. Nasby" <decibel@decibel.org>
Cc: Dave Held <dave.held@arrayservicesgrp.com>, pgsql-performance@postgresql.org
Date: 2005-04-20T03:01:26Z
Lists: pgsql-performance 
"Jim C. Nasby" <decibel@decibel.org> writes:
> Actually, the planner (at least in 7.4) isn't smart enough to consider
> if the sort would fit in memory or not.

Really?  Have you read cost_sort()?

It's certainly possible that the calculation is all wet, but to claim
that the issue is not considered is just wrong.

			regards, tom lane