On Oct 13, 2015 17:08, "Eric Wong" <Eric.Wong@solvians.com> wrote:

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