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

Reply via email to