Hello 2011/4/11 Clemens Eisserer <linuxhippy@xxxxxxxxx>: > Hi, > > We are working on an university project for network traffic accounting. > We use ulogd-2 to log netfilter packets, however it creates for each > packet a seperate transaction and also doesn't use prepared > statements, which results in horrible performance. > > What we are looking for is a low-overhead way of inserting many rows > (100-1000) into a table at once in one transaction. > Is "COPY FROM STDIN" Âa good idea in this case? sure > > If so, are there some examples how to use "COPY FROM STDIN" with the > native C API? look to source code on \copy implementation in psql http://doxygen.postgresql.org/bin_2psql_2copy_8c.html http://www.postgresql.org/docs/8.1/static/libpq-copy.html Regards Pavel Stehule > I found some documentation, however as I am no C native some sample > code would really help. > > Thank you in advance, Clemens > > PS: Sorry for the cross post, I accidentially sent it to the jdbc list before. > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
