On 27 April 2016 at 20:42, Anthony Rodriguez < anthony.rodrig...@netwolves.com> wrote:
> Hi, > > I have set up a test capturing NF into a postgresql 8.4 DB. It seems to > work OK but the writing to the DB seems > to get far behind. I had one writer take 1.5 hours to sync. Any hints > would be appreciated. > > Apr 27 10:30:01 nfacctd[31907]: INFO ( default/pgsql ): *** Purging cache > - START (PID: 31907) *** > Apr 27 12:59:39 nfacctd[31907]: INFO ( default/pgsql ): *** Purging cache > - END (PID: 31907, QN: 12482/32819, ET: 8978) *** > > Have you considered moving to INSERTs rather than UPDATEs? Config key is " sql_dont_try_update " M
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists