sorry, missed ths one.
first, you can take a look at this article
http://www.rsyslog.com/doc/rsyslog_high_database_rate.html
but the bigger win is that ompgsql now supports batch mode inserts. This allows
the plugin to deliver many logs to postgres as one transaction (this is one of
the reasons that batch processing was added to rsyslog in the first place) You
probably want to set the batch size to something quite large, I've seen inserts
of 1000 rows be as fast as inserts for a single row in testing on some hardware,
so experiment and don't be afraid of going really large (just make sure you have
a large enough queue to support this)
David Lang
On Tue, 13 Aug 2013, Erik Steffl wrote:
Any thoughts on DB output? Redshift can use Postgresql client, seems like
there is ompgsql (see it mentioned at
http://www.rsyslog.com/doc/rsyslog_conf_modules.html) but don't see any links
to docs.
_______________________________________________
rsyslog mailing list
http://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE
THAT.
