[Prelude Hybrid IDS] #225: PostgreSQL base schema is (really) slow
"Prelude Hybrid IDS" <[email protected]>
| Newsgroups | gmane.comp.security.ids.prelude.devel |
|---|---|
| Message-ID | <[email protected]> |
#225: PostgreSQL base schema is (really) slow -------------------------------------------------+-------------------------- Reporter: Pierre Chifflier <[email protected]> | 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 _______________________________________________ Prelude-devel site list [email protected] http://www.prelude-ids.org/mailman/listinfo/prelude-devel