Re: Postgresql "FIFO" Tables, How-To ? - Mailing list pgsql-general

From Kirill Ponazdyr
Subject Re: Postgresql "FIFO" Tables, How-To ?
Date
Msg-id 2911.192.168.1.3.1058375341.squirrel@www.codeangels.com
Whole thread Raw
In response to Re: Postgresql "FIFO" Tables, How-To ?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Responses Re: Postgresql "FIFO" Tables, How-To ?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Re: Postgresql "FIFO" Tables, How-To ?  (Florian Weimer <fw@deneb.enyo.de>)
List pgsql-general
> Frankly I would like to know fist why do you want to do this. Unless there
> are
> good enough practical reasons, I would not recommend this approach at all.
> Can
> you tell us why do you want to do this?
>

It is for a advanced syslog server product we are currently developing.

The very basic idea is to feed all syslog messages into a DB and allow
easy monitoring and even correlation, we use Postgres as our DB Backend,
in big environments the machine would be hit with dozens of syslog
messages in a second and the messaging tables could grow out of controll
pretty soon (We are talking of up to 10mil messages daily).

We do have a "cleansing" logic build in which runs at certain times and
could delete the records over limit. So FIFO is not a requirement, it was
actually rather a theoretical question.

Regards

Kirill

--
Kirill Ponazdyr
Technical Director
Codeangels Solutions GmbH
Tel: +41 (0)43 844 90 10
Fax: +41 (0)43 844 90 12
Web: www.codeangels.com

pgsql-general by date:

Previous
From: "Brian Maguire"
Date:
Subject: Couple Postgres View Questions
Next
From: Luis Magaña
Date:
Subject: Re: ODBC query problem