I am not sure if you judge the right thing. The way ompgsql is programmed is that it does a begin transaction ... insert (n times) ... end transaction. However, each of these statements is sent via a separate call to the postgres lib. May it be that you are tracing the library calls and not the transactions?
Rainer > -----Original Message----- > From: [email protected] [mailto:rsyslog- > [email protected]] On Behalf Of Kenneth Marshall > Sent: Friday, December 11, 2009 3:06 PM > To: rsyslog-users > Subject: Re: [rsyslog] rsyslog 5.3.5 (v5-beta) released > > On Fri, Dec 11, 2009 at 01:04:25PM +0100, Rainer Gerhards wrote: > > if not subscribed to it, revisit bug tracker or forum post, there now > exist a > > patch! :) > > > > Rainer > > > Thank you Rainer. It now logs once more. Unfortunately, I am having > trouble getting the INSERT batching to work. Here is my current > rsyslog.conf: > > $ModLoad immark # provides --MARK-- message capability > $ModLoad imtcp # provides TCP syslog reception and GSS-API (if compiled > to support it) > $ModLoad imuxsock > $InputTCPServerRun 601 # listen on this port > $WorkDirectory /var/spool/rsyslog # default location for work (spool) > files > #$MainMsgQueueFileName mainq # set file name, also enables disk mode > $ActionQueueType LinkedList # use asynchronous processing > $ActionQueueDequeueBatchSize 16 > $ActionQueueFileName dbq # set file name, also enables disk mode > $ActionResumeRetryCount -1 # infinite retries on insert failure > $ModLoad ompgsql # provides postgres support > # Everything we receive goes in the database > *.* :ompgsql:127.0.0.1,Syslog,dbuser,xxxxxx > > The $ActionQueueDequeueBatchSize option does not appear to have > any effect. The inserts are still performed one at a time. Any > ideas? > > Regards, > Ken > > _______________________________________________ > rsyslog mailing list > http://lists.adiscon.net/mailman/listinfo/rsyslog > http://www.rsyslog.com _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com
