[ovirt-users] Archiving huge ovirt_engine_history table

[Eric Wong]

Hello oVirt guru out there:

I notice our oVirt engine postgres db size is growing quite fast for past couple of months.  I checked the database size.  Found that our ovirt_engine_history is 73GB in size.


engine=# \connect ovirt_engine_history
You are now connected to database "ovirt_engine_history" as user "postgres".
ovirt_engine_history=# SELECT pg_size_pretty( pg_database_size( current_database() ) ) As human_size
   , pg_database_size( current_database() ) As raw_size;
human_size |  raw_size
------------+-------------
73 GB      | 78444213368
(1 row)


Brief check the records, there are entries dated back 2014.

I want to see if there is a safe way to archive and remove some of the older records?

Thanks,
Eric

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20151014/32d2343b/attachment.html>