On 4/7/06, Sven Anderson <[EMAIL PROTECTED]> wrote: > > Is there a tuning problem, or is PostgreSQL known to be not as fast as > MySQL? I thought, maybe there are some kind of rollback journals written, > which MySQL doesn't, or the hash-tables are not indexed correctly? Any ideas?
It could be a myriad of issues. Have you changed any of the default PostgreSQL settings? PostgreSQL, by default, is not configured for anything but pure compatibility - meaning it will certainly work, but not at it's best. For what it's worth, I had PostgreSQL and pmacct on an OpenBSD 3.8 box and experienced no problems past the 1.2million row mark (I shutdown that installation for unrelated reasons). If you are not familiar with PostgreSQL - definitely start reading here[1] regards, aaron.glenn [1]http://www.postgresql.org/docs/8.1/interactive/runtime-config.html
