Project

General

Profile

Bug #225

PostgreSQL base schema is (really) slow

Added by admin admin almost 17 years ago. Updated almost 15 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Yoann VANDOORSELAERE
Target version:
0.9.13
Start date:
Due date:
% Done:

0%

Resolution:
fixed

Description

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

numeric_to_bigint.patch View - Convert numeric(20) types to int8 (455 Bytes) admin admin, 05/16/2007 11:19 AM

add_index.sql View - Add indexes to Prelude_Service, Prelude_Node and Prelude_Process (260 Bytes) admin admin, 05/16/2007 11:20 AM

update_pg_types.sql View - Upgrade script for PostgreSQL db (2.32 KB) admin admin, 05/16/2007 11:53 AM

History

#1 Updated by Yoann VANDOORSELAERE almost 17 years ago

  • Status changed from New to Closed
  • Resolution set to fixed

(In r9537) Patch by Pierre Chifflier <>, fixing
type conversions preventing [[PostgreSQL]] to use indexes (fix #225).

Additionally, update schema version number to 14.7.

#2 Updated by Yoann VANDOORSELAERE almost 17 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 almost 15 years ago

  • Project changed from PRELUDE SIEM to LibpreludeDB
  • Category deleted (2)
  • Target version deleted (0.9.13)

Also available in: Atom PDF