Re: Sort and index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: Dave Held <dave(dot)held(at)arrayservicesgrp(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Sort and index
Date: 2005-04-20 03:01:26
Message-ID: 19631.1113966086@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Jim C. Nasby" <decibel(at)decibel(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-04-20 03:05:54 Re: Slow copy with little CPU/disk usage
Previous Message Jim C. Nasby 2005-04-20 02:00:33 Slow copy with little CPU/disk usage