[Speakers] Re: Centralized Logging

[Bruce Smith]

> > Just curious, but what's the advantage(s) of logging to a database over
> > standard syslogd text files?  i.e. Why did you do this?
> 
> Easier to manage and search mostly.  

Yeah, I thought of the search thing.  I thought maybe there were fancy
reporting packages that required a DB, or some other reason.

> Another instance is the occasional user call whining about how they sent
> some e-mail message and the other end claims they never got it.

Gee, never seen that before!  ;-)

> [BTW, the message *ALWAYS* goes through just fine,  but users are
> frequently convinced that the system 'lost it'.

Yup, amazing how that works.

> My favorite was the
> furious arm waving user who had set their SIEVE filter to delete ALL
> incoming mail.

Wow ...  :-)

> But you really want to index that table as it appears we generate
> 250,000+ log messages a day.  So if I keep data for 30 days that will be
> ~7.5 million records.  Wow.

How often do you vacuum/reindex/whatever the tables?

 - BS