[prelude-devel] [Prelude Hybrid IDS] #225: PostgreSQL base schema is (really) slow

[Prelude Hybrid IDS]

#225: PostgreSQL base schema is (really) slow
-------------------------------------------------+--------------------------
 Reporter:  Pierre Chifflier <chifflier at inl.fr>  |       Owner:  yoann
     Type:  defect                               |      Status:  new  
 Priority:  normal                               |   Milestone:       
Component:  libpreludedb                         |     Version:  0.9  
 Severity:  normal                               |    Keywords:       
-------------------------------------------------+--------------------------
 The PostgreSQL schema definitly needs some love, performances are really
 bad.

 Some identified problems:
  * type conversions preventing postgresql to use indexes (numeric(20), for
 example)
  * some missing indexes

-- 
Ticket URL: <https://trac.prelude-ids.org/ticket/225>
Prelude Hybrid IDS <http://www.prelude-ids.org>
The Prelude Hybrid Intrusion Detection System suite