pytypestest.sql.out

application/octet-stream

Filename: pytypestest.sql.out
Type: application/octet-stream
Part: 1
Message: Re: plpython3 perf
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
DROP TYPE
CREATE TYPE
CREATE FUNCTION
 noparams 
----------
 
(1 row)

BEGIN
Timing is on.
  base  
--------
 100000
(1 row)

Time: 61.031 ms
 basesql 
---------
  100000
(1 row)

Time: 55.993 ms
 noparams 
----------
   100000
(1 row)

Time: 372.552 ms
 oneint2 
---------
  100000
(1 row)

Time: 684.318 ms
 oneint4 
---------
  100000
(1 row)

Time: 678.396 ms
 oneint8 
---------
  100000
(1 row)

Time: 676.250 ms
 oneint8_large 
---------------
        100000
(1 row)

Time: 695.032 ms
  text  
--------
 100000
(1 row)

Time: 1153.955 ms
 text_large 
------------
     100000
(1 row)

Time: 2766.764 ms
 textarray 
-----------
    100000
(1 row)

Time: 715.568 ms
 composite 
-----------
    100000
(1 row)

Time: 795.862 ms
ROLLBACK
Time: 2.181 ms