Re: Problems with base and postgresql

[Alejandro Flores <alejandrorflores () gmail com>]

Hey,

> Still got problems with my BASE. I'm running Snort 2.3 with BASE 1.0.2 on a
> PostgreSQL 7.4.3 server. Snort is producing some alarms, but not too many.
> Not always but often the server has a load of 99,9% because of postmaster
> doing some INSERTS etc. The same is happening, when I'm doing some queries
> with BASE. The system needs plenty of time to show me the results. 
> Do you have any ideas, why this happens? I have already read some
> instructions how to tune my database with indexes etc. But I don't exactly
> know, how I could do this. 
> Can you help me? 

Could you post here the startup line of your postgresql? What options
are you using?

Regards,
Alejandro Flores


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users