Re: calculating time - Mailing list pgsql-general

From Tom Lane
Subject Re: calculating time
Date
Msg-id 18019.1050504691@sss.pgh.pa.us
Whole thread Raw
In response to Re: calculating time  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Alvaro Herrera <alvherre@dcc.uchile.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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: will an honest French ISP please stand up
Next
From: Tom Lane
Date:
Subject: Re: will an honest French ISP please stand up