Re: [ovirt-users] huge ovirt_engine_history

[Yaniv Dary]

You can change the setting for how long data is saved in the dwh conf
directory, there is a readme with details in the 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: yd...@redhat.com
IRC : ydary
On Oct 13, 2015 17:08, "Eric Wong"  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
>
___
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users

[ovirt-users] huge ovirt_engine_history

[Eric Wong]

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