Re: [ovirt-users] Archiving huge ovirt_engine_history table

[Yaniv Dary]

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: yd...@redhat.com
IRC : ydary


On Wed, Oct 14, 2015 at 5:15 AM, 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] Archiving huge ovirt_engine_history table

[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