Re: Syslog to postgresql - need peaks of 5.000/s - Mailing list pgsql-admin

From Michael Monnerie
Subject Re: Syslog to postgresql - need peaks of 5.000/s
Date
Msg-id 200801290115.50295@zmi.at
Whole thread Raw
In response to Re: Syslog to postgresql - need peaks of 5.000/s  (paul rivers <rivers.paul@gmail.com>)
List pgsql-admin
On Samstag, 26. Januar 2008 paul rivers wrote:
> Anyway, that's my experience with this, hope it helps.

Dear Paul, thanks a lot for the very detailed information. I'm more
relaxed now as it seems to be possible to do everything I wanted,
although I'm concerned that 5.000 inserted lines per second could be a
problem. I'll just start with a server and then see it's limits and
what more I need.

BTW, this information could be very interesting for you. According to
syslog, they will release the "direct syslog to postgresql"
feature soon:
http://www.balabit.com/network-security/syslog-ng/

You might not change the running process, but for a new implementation
this could make things much easier.

mfg zmi
--
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0676/846 914 666                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: www.keyserver.net                   Key-ID: 1C1209B4

Attachment

pgsql-admin by date:

Previous
From: "Spiegelberg, Greg"
Date:
Subject: Re: Zen and art if WAL and dump file mainteance
Next
From: Julio Leyva
Date:
Subject: WAL files and heckpoints