You can configure the DWH via the conf.d to save less records.
See the readme in that folder.
Yaniv Dary
Technical Product Manager
Red Hat Israel Ltd.
34 Jerusalem Road
Building A, 4th floor
Ra'anana, Israel 4350109
Tel : +972 (9) 7692306
8272306
Email: ydary(a)redhat.com
IRC : ydary
On Wed, Oct 14, 2015 at 5:15 AM, Eric Wong <Eric.Wong(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users