Project

General

Profile

Bug #356

LibpreludeDB + postgresql 8.3 + preludedb-admin delete alert = tooo low

Added by Vitaly Tskhovrebov almost 15 years ago. Updated over 7 years ago.

Status:
Closed
Priority:
High
Assignee:
Thomas ANDREJAK
Target version:
-
Start date:
06/29/2009
Due date:
% Done:

0%

Resolution:

Description

libpreludedb 0.9.15.1
postgresql 8.3 default installation
prelude-manager 0.9.14.2

preludedb-admin delete alert --criteria "alert.create_time < 2009-02-23" "type=pgsql name=prelude user=prelude pass=111"

Database is about 200GB size.
This command takes execution time more than 4 days, and can be more, but cisco router has been rebooted by network team.

This is tooo low. When executing, postgres deleting process takes about 80% CPU.

History

#1 Updated by Jean-Charles ROGEZ almost 12 years ago

  • Project changed from PRELUDE SIEM to LibpreludeDB
  • Category deleted (idmef)

#2 Updated by Thomas ANDREJAK over 7 years ago

  • Status changed from New to Closed
  • Assignee changed from Yoann VANDOORSELAERE to Thomas ANDREJAK

Also available in: Atom PDF