[Snort-users] insert speed of mysql v. postgresql
cmg at ...671...
Thu Jan 18 12:48:12 EST 2001
You're correct <red face>. The optimization to do is to add -o "-o
-F" to the pg_ctl start line to disable an fsync between each db
call and that brings the postgres speeds to roughly same as
mysql. I'll have to grab a much larger log file before I answer
anything more on speed.
I bet that mysqld --flush takes the same performance hit. I think
it's a matter of defaults.
Martin Roesch <roesch at ...421...> writes:
> I think that something else is going on here, Postgres is supposed to be
> very capable these days (some drag races have it faster than MySQL
> even). Perhaps there is some optimization that could be performed in
> the plugin as well as at the administrative end of the database?
Chris Green <cmg at ...671...>
Fame may be fleeting but obscurity is forever.
More information about the Snort-users