On Wed, Dec 7, 2016 at 4:10 AM, Tom DalPozzo <t.dalpo...@gmail.com> wrote: > Hi, > I tried both ways: they're ok. > Also, multiple VALUES in one INSERT is actually better as performance.
If you are chasing performance with the binary protocol you might want to take a look at libpqtypes: http://libpqtypes.esilo.com/ It facilitates fast communication to/from the database. For inserting, you stack an array of composites locally and send it to the database with a single query and the receiving side can unwrap it and do the insert in a function. Advancements in json handling have largely displaced this kind of usage in many situations but if you have extreme performance requirements it's still worth a look. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
