Re: calculating time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>, "pg-general (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: calculating time
Date: 2003-04-16 14:51:31
Message-ID: 18019.1050504691@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> One thing I've wondered is if one can trust the "conversion" to keep
> roughly the same from one query to another,

If the planner's units don't bear some reasonably linear relationship
to the real world, then its cost estimation process doesn't work at all.
So yeah, on any given machine there ought to be a fairly consistent
conversion.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-16 15:13:31 Re: will an honest French ISP please stand up
Previous Message Tom Lane 2003-04-16 14:48:22 Re: will an honest French ISP please stand up