Postgres Pro
Downloads
Home   >   mailing lists

Re: Mystery function error - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Mystery function error
Date
Msg-id 200309281147.41146.josh@agliodbs.com
Whole thread Raw
In response to Re: Mystery function error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Mystery function error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Tom,

> position()    1 usec/call    1 usec/call
> SQL func    1 usec/call    90 usec/call
> plpgsql func    110 usec/call    100 usec/call

Hmmm ... this does still seem to show that plpgsql is 10% slower in 7.4.  Any 
idea why?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-sql by date:

Previous
From: "Muhyiddin A.M Hayat"
Date:
Subject: SUM() & GROUP BY
Next
From: Tom Lane
Date:
Subject: Re: Mystery function error