Any tips for this particular performance problem?

If you have time, take a quick look at

http://acidlab.sourceforge.net/perf/acid_perf.html

PostgreSQL has serious scalability problems with snort + acid. Any
advices?

(Now I'm using MySQL with my SNORT/ACID setup, but I'm willing to
change to PostgreSQL if more tests are needed)

Sergio Bruder

-- 
Coordenação de Desenvolvimento - Projetos Especiais, Conectiva
http://www.conectiva.com.br, http://sergio.bruder.net, http://pontobr.org
-----------------------------------------------------------------------------
pub  1024D/0C7D9F49 2000-05-26 Sergio Devojno Bruder <bruder@conectiva.com.br>    Key fingerprint = 983F DBDF FB53 FE55
87DF 71CA 6B01 5E44 0C7D 9F49
 
sub  1024g/138DF93D 2000-05-26