PostgreSQL base schema is (really) slow
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
- Status changed from New to Closed
- Resolution set to fixed
(In r9537) Patch by Pierre Chifflier <email@example.com>, fixing
type conversions preventing [[PostgreSQL]] to use indexes (fix #225).
Additionally, update schema version number to 14.7.
Checked in r9537, thanks!
Work remain to be done concerning the index part of your patches, a complete fix should make-it to the repository as soon as we'll be done with the analysis/code.
- Project changed from PRELUDE SIEM to LibpreludeDB
- Category deleted (
- Target version deleted (
Also available in: Atom