469,362 Members | 2,450 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,362 developers. It's quick & easy.

snort, acid and postgres

Ok, so here is my problem. I am running snort with ACID as the query
interface and FreeBSD with Postgresql 7.2 as the back end database
system. The problem I am encountering is that it takes forever for acid
to query the database and delete alerts. Also, there is no way to have
more than one person query the database without having it crawl. Is
there anyone out there that has experience tweaking postgres so that it
performs faster in this setup? The database is out of the box with no
tweaks to it.

thanks,

Jeremy

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #1
1 2577
There are some web pages that provide specific hints for tuning the
snort + ACID combination, e.g:

http://www.andrew.cmu.edu/~rdanyliw/...aq.html#faq_c9

Having said that, it is worth collecting the information Dann suggested,
as folk on this list can probably give you database tuning tips that the
standard FAQs may not contain.

regards

Mark
Jeremy Hefner wrote:
Ok, so here is my problem. I am running snort with ACID as the query
interface and FreeBSD with Postgresql 7.2 as the back end database
system. The problem I am encountering is that it takes forever for acid
to query the database and delete alerts. Also, there is no way to have
more than one person query the database without having it crawl. Is
there anyone out there that has experience tweaking postgres so that it
performs faster in this setup? The database is out of the box with no
tweaks to it.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bryan Miller | last post: by
3 posts views Thread by warwick.poole | last post: by
1 post views Thread by Jack Orenstein | last post: by
1 post views Thread by RobG | last post: by
reply views Thread by krithika.143 | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.