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
#1 Updated by Yoann VANDOORSELAERE about 16 years ago
- 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.
#2 Updated by Yoann VANDOORSELAERE about 16 years ago
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.
#3 Updated by Yoann VANDOORSELAERE about 14 years ago
- Project changed from PRELUDE SIEM to LibpreludeDB
- Category deleted (
- Target version deleted (