
13 Oct
2015
13 Oct
'15
3:59 p.m.
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