Re: Question about cost-calculation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question about cost-calculation
Date: 2008-06-02 13:57:17
Message-ID: 17613.1212415037@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> writes:
> i expected for a 1000 row test-table a cost per function of 2.5
> (cpu_operator_cost = 0.0025), but i got 5.

What's the data type of "i"? I suspect you really have two function
calls in that expression: a type coercion function and cos() itself.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2008-06-02 14:06:45 Re: Question about cost-calculation
Previous Message hubert depesz lubaczewski 2008-06-02 13:45:27 Re: why so many open files?