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

 

_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users