Yeah we have considered this, and are attempting it. What does the QN and ET parts of the statement mean when purging?
Ex: QN: 12482/32819, ET: 8978

On 04/28/2016 08:01 AM, Matthew Walster wrote:
On 27 April 2016 at 20:42, Anthony Rodriguez <anthony.rodrig...@netwolves.com <mailto: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

--
Anthony Rodriguez
Software Engineer I
NetWolves
Email: anthony.rodrig...@netwolves.com
www.netwolves.com

_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Reply via email to