Re: Query plan question, and a memory leak

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Query plan question, and a memory leak
Date: 2003-02-03 04:24:43
Message-ID: 29834.1044246283@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark <gsstark(at)mit(dot)edu> writes:
> I wouldn't expect it to actually take any more time. In fact I would expect it
> to take a lot less time since it takes time to handle the resulting data too.

You're mistaking planner estimate time for reality ;-).

IIRC, the planner doesn't bother to account for evaluation time of
select-list values in its estimates. At least in simple cases, there's
no point in doing that math because the cost will be the same no matter
what plan is chosen.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2003-02-03 04:38:43 Re: Query plan question, and a memory leak
Previous Message Lincoln Yeoh 2003-02-03 03:42:53 Re: sorting RTL languages.