pg_proboscis 0.9 release
James William Pye
pgsql at jwp.name
Tue Jan 8 18:42:29 UTC 2008
Yeah, I finally released something. It's just the driver, but it will help pave
the future for the PL(API-wise and slythe). :)
There are many marked improvements, and I would like to list them all, but it's
been a work in progress for some time now, so I forget many of them. And, yes, this
breaks things if you use 0.1; so the documentation currently available on the website
is mostly invalid.
:P
+ pypi distribution/setuptools build process.
+ COPY improvments (COPY queries return a ResultHandle object for managing the copy)
+ simplified type I/O management; now returns standard Python object
+ Binary timestamp support; (including timestamptz support with pytz package)
+ Improved array support.
+ Better interrupt safety.
+ first() method (~ shorthand)
+ "Transaction" connection objects for managing transactions.
+ Improved server settings interface("con.Settings")
+ "re-connectable" connections; I believe in 0.1 you had to create a new
connection.
- WireTap has been removed; likely to be replaced in 1.0.
Some example performance numbers:
jwp at torch[]:pkg/src/lo 0% pg_tin com pb_python -m postgresql.protocol.greentrunk.test.perf_copy_io
preparing data(150000 tuples)...
starting copy...
COPY FROM STDIN Summary,
copied tuples: 150000
copied bytes: 8729741
duration: 1.036334
average tuple size(bytes): 58.000000
average KB per second: 8226.112131
average tuples per second: 144740.975913
COPY TO STDOUT Summary,
copied tuples: 150000
duration: 0.871910
average KB per second: 9777.386886
average tuples per second: 172036.132899
jwp at torch[]:pkg/src/lo 0% pg_tin com pb_python -m postgresql.protocol.greentrunk.test.perf_query_io
INSERT Summary,
inserted tuples: 15000
total time: 1.272875
average tuples per second: 11784.345806
SELECT Summary,
looped/tuples: 15000
looptime: 0.627941
average tuples per second: 23887.598599
More information about the Python-general
mailing list