Thanks Tom. We're running this now in production, to see
what the less technical staff make of it.
Tom Kistner wrote:
> When the agent is started, it will pump the current log file
> into the database (this can take a while), then tail it. It
> will automatically detect log rotation and re-open the file
> if necessary.
>
>
> Done! Report bugs and suggestions to me.
Against a pgsql backend (on a seperate machine),
the performance of the initial import has fallen off by
a factor of three after about 180MB of mainlog and 31MB
of reject has been swallowed.
A "vacuum analyze" of the messages and rejects tables
at this time (or earlier, had I thought of it) is A Good Thing,
as the query planner doesn't really sit up and take notice of
the indices until that's done.
This could be added to the docs :)
Do any of the opensource DBs do this sort of thing automagically?
- Jeremy