Postgres Pro
Downloads
Home   >   mailing lists

Re: profiling plpgsql functions.. - Mailing list pgsql-performance

From Tom Lane
Subject Re: profiling plpgsql functions..
Date
Msg-id 1910.1051632095@sss.pgh.pa.us
Whole thread Raw
In response to Re: profiling plpgsql functions..  (<mallah@trade-india.com>)
Responses Re: profiling plpgsql functions..
List pgsql-performance
Tree view 
<mallah@trade-india.com> writes:
> hmm shud i cast timeofday to timestamp  and use timestamp
> arithmatic ?

Yeah.  It's only historical accident that it doesn't return timestamp...
(or better use timestamptz)

            regards, tom lane

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: profiling plpgsql functions..
Next
From: "SZŰCS Gábor"
Date:
Subject: Re: Query Plan far worse in 7.3.2 than 7.2.1