plpythontest.sql.out

application/octet-stream

Filename: plpythontest.sql.out
Type: application/octet-stream
Part: 0
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: 63.008 ms
 basesql 
---------
  100000
(1 row)

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

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

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

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

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

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

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

Time: 2310.369 ms
SAVEPOINT
Time: 0.103 ms
ROLLBACK
Time: 0.248 ms
 composite 
-----------
    100000
(1 row)

Time: 1654.982 ms
ROLLBACK
Time: 0.249 ms