X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BC288475E9D for ; Thu, 1 May 2003 10:57:40 -0400 (EDT) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id A6EE5475FBA for ; Thu, 1 May 2003 10:57:29 -0400 (EDT) Received: (qmail 13200 invoked from network); 1 May 2003 14:58:25 -0000 Received: from unknown (HELO system67.trade-india-local.com) (unknown) by unknown with SMTP; 1 May 2003 14:58:25 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: Tom Lane Subject: Re: profiling plpgsql functions.. Date: Thu, 1 May 2003 20:29:16 +0530 User-Agent: KMail/1.5 Cc: pgsql-performance@postgresql.org References: <200304291655.01035.mallah@trade-india.com> <1066.219.65.230.214.1051631768.squirrel@mail.trade-india.com> <1910.1051632095@sss.pgh.pa.us> In-Reply-To: <1910.1051632095@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305012029.16516.mallah@trade-india.com> X-Spam-Status: No, hits=-33.1 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,SIGNATURE_SHORT_SPARSE, USER_AGENT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/1 X-Sequence-Number: 1780 the profiling was really helpful to track down an absense of an appropriate index. believe me or not the overall speed improvement was 50 times :)) from the order of .4 sec to .008 secs per function call regds mallah. On Tuesday 29 Apr 2003 9:31 pm, Tom Lane wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.