From Eric.Wong at solvians.com Tue Oct 13 22:15:41 2015 Content-Type: multipart/mixed; boundary="===============6471052655868016099==" MIME-Version: 1.0 From: Eric Wong To: users at ovirt.org Subject: [ovirt-users] Archiving huge ovirt_engine_history table Date: Wed, 14 Oct 2015 02:15:37 +0000 Message-ID: <2ad2e929edd04ef4a923887e0c9ab804@MSEX-04-FRA9.corp.solvians.com> --===============6471052655868016099== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable --_000_2ad2e929edd04ef4a923887e0c9ab804MSEX04FRA9corpsolviansc_ Content-Type: text/plain; charset=3D"iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello oVirt guru out there: I notice our oVirt engine postgres db size is growing quite fast for past c= =3D ouple of months. I checked the database size. Found that our ovirt_engine= =3D _history is 73GB in size. engine=3D3D# \connect ovirt_engine_history You are now connected to database "ovirt_engine_history" as user "postgres"= =3D . ovirt_engine_history=3D3D# SELECT pg_size_pretty( pg_database_size( current= _d=3D atabase() ) ) 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 olde= =3D r records? Thanks, Eric --_000_2ad2e929edd04ef4a923887e0c9ab804MSEX04FRA9corpsolviansc_ Content-Type: text/html; charset=3D"iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello oVirt guru out there:

I notice our oVirt engine postgres db size is growing quite fast for past c= =3D ouple of months.  I checked the database size.  Found that our ov= =3D irt_engine_history is 73GB in size.  


engine=3D3D# \connect ovirt_engine_history
You are now connected to database "ovirt_engine_history" as user = =3D "postgres".
ovirt_engine_history=3D3D# SELECT pg_size_pretty( pg_database_size( current= _d=3D atabase() ) ) 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 olde= =3D r records?

Thanks,
Eric

 

--_000_2ad2e929edd04ef4a923887e0c9ab804MSEX04FRA9corpsolviansc_-- --===============6471052655868016099== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" LS1fMDAwXzJhZDJlOTI5ZWRkMDRlZjRhOTIzODg3ZTBjOWFiODA0TVNFWDA0RlJBOWNvcnBzb2x2 aWFuc2NfCkNvbnRlbnQtVHlwZTogdGV4dC9wbGFpbjsgY2hhcnNldD0iaXNvLTg4NTktMSIKQ29u dGVudC1UcmFuc2Zlci1FbmNvZGluZzogcXVvdGVkLXByaW50YWJsZQoKSGVsbG8gb1ZpcnQgZ3Vy dSBvdXQgdGhlcmU6CgpJIG5vdGljZSBvdXIgb1ZpcnQgZW5naW5lIHBvc3RncmVzIGRiIHNpemUg aXMgZ3Jvd2luZyBxdWl0ZSBmYXN0IGZvciBwYXN0IGM9Cm91cGxlIG9mIG1vbnRocy4gIEkgY2hl Y2tlZCB0aGUgZGF0YWJhc2Ugc2l6ZS4gIEZvdW5kIHRoYXQgb3VyIG92aXJ0X2VuZ2luZT0KX2hp c3RvcnkgaXMgNzNHQiBpbiBzaXplLgoKCmVuZ2luZT0zRCMgXGNvbm5lY3Qgb3ZpcnRfZW5naW5l X2hpc3RvcnkKWW91IGFyZSBub3cgY29ubmVjdGVkIHRvIGRhdGFiYXNlICJvdmlydF9lbmdpbmVf aGlzdG9yeSIgYXMgdXNlciAicG9zdGdyZXMiPQouCm92aXJ0X2VuZ2luZV9oaXN0b3J5PTNEIyBT RUxFQ1QgcGdfc2l6ZV9wcmV0dHkoIHBnX2RhdGFiYXNlX3NpemUoIGN1cnJlbnRfZD0KYXRhYmFz ZSgpICkgKSBBcyBodW1hbl9zaXplCiAgICwgcGdfZGF0YWJhc2Vfc2l6ZSggY3VycmVudF9kYXRh YmFzZSgpICkgQXMgcmF3X3NpemU7Cmh1bWFuX3NpemUgfCAgcmF3X3NpemUKLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0KNzMgR0IgICAgICB8IDc4NDQ0MjEzMzY4CigxIHJvdykKCgpCcmllZiBj aGVjayB0aGUgcmVjb3JkcywgdGhlcmUgYXJlIGVudHJpZXMgZGF0ZWQgYmFjayAyMDE0LgoKSSB3 YW50IHRvIHNlZSBpZiB0aGVyZSBpcyBhIHNhZmUgd2F5IHRvIGFyY2hpdmUgYW5kIHJlbW92ZSBz b21lIG9mIHRoZSBvbGRlPQpyIHJlY29yZHM/CgpUaGFua3MsCkVyaWMKCgotLV8wMDBfMmFkMmU5 MjllZGQwNGVmNGE5MjM4ODdlMGM5YWI4MDRNU0VYMDRGUkE5Y29ycHNvbHZpYW5zY18KQ29udGVu dC1UeXBlOiB0ZXh0L2h0bWw7IGNoYXJzZXQ9Imlzby04ODU5LTEiCkNvbnRlbnQtVHJhbnNmZXIt RW5jb2Rpbmc6IHF1b3RlZC1wcmludGFibGUKCjxodG1sIHhtbG5zOnY9M0QidXJuOnNjaGVtYXMt bWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89M0QidXJuOnNjaGVtYXMtbWljcj0Kb3NvZnQtY29t Om9mZmljZTpvZmZpY2UiIHhtbG5zOnc9M0QidXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTpvZmZp Y2U6d29yZCIgPQp4bWxuczptPTNEImh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vb2ZmaWNl LzIwMDQvMTIvb21tbCIgeG1sbnM9M0QiaHR0cDo9Ci8vd3d3LnczLm9yZy9UUi9SRUMtaHRtbDQw Ij4KPGhlYWQ+CjxtZXRhIGh0dHAtZXF1aXY9M0QiQ29udGVudC1UeXBlIiBjb250ZW50PTNEInRl eHQvaHRtbDsgY2hhcnNldD0zRGlzby04ODU5LT0KMSI+CjxtZXRhIG5hbWU9M0QiR2VuZXJhdG9y IiBjb250ZW50PTNEIk1pY3Jvc29mdCBXb3JkIDE0IChmaWx0ZXJlZCBtZWRpdW0pIj4KPHN0eWxl PjwhLS0KLyogRm9udCBEZWZpbml0aW9ucyAqLwpAZm9udC1mYWNlCgl7Zm9udC1mYW1pbHk6SGVs dmV0aWNhOwoJcGFub3NlLTE6MiAxMSA2IDQgMiAyIDIgMiAyIDQ7fQpAZm9udC1mYWNlCgl7Zm9u dC1mYW1pbHk6IkNhbWJyaWEgTWF0aCI7CglwYW5vc2UtMToyIDQgNSAzIDUgNCA2IDMgMiA0O30K QGZvbnQtZmFjZQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7CglwYW5vc2UtMToyIDE1IDUgMiAyIDIg NCAzIDIgNDt9Ci8qIFN0eWxlIERlZmluaXRpb25zICovCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3Jt YWwsIGRpdi5Nc29Ob3JtYWwKCXttYXJnaW46MGluOwoJbWFyZ2luLWJvdHRvbTouMDAwMXB0OwoJ Zm9udC1zaXplOjEyLjBwdDsKCWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLCJzZXJpZiI7 fQphOmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5OwoJY29s b3I6Ymx1ZTsKCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQphOnZpc2l0ZWQsIHNwYW4uTXNv SHlwZXJsaW5rRm9sbG93ZWQKCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7Cgljb2xvcjpwdXJwbGU7 Cgl0ZXh0LWRlY29yYXRpb246dW5kZXJsaW5lO30Kc3Bhbi5FbWFpbFN0eWxlMTcKCXttc28tc3R5 bGUtdHlwZTpwZXJzb25hbC1jb21wb3NlOwoJZm9udC1mYW1pbHk6IkNhbGlicmkiLCJzYW5zLXNl cmlmIjsKCWNvbG9yOndpbmRvd3RleHQ7fQouTXNvQ2hwRGVmYXVsdAoJe21zby1zdHlsZS10eXBl OmV4cG9ydC1vbmx5OwoJZm9udC1mYW1pbHk6IkNhbGlicmkiLCJzYW5zLXNlcmlmIjt9CkBwYWdl IFdvcmRTZWN0aW9uMQoJe3NpemU6OC41aW4gMTEuMGluOwoJbWFyZ2luOjEuMGluIDEuMGluIDEu MGluIDEuMGluO30KZGl2LldvcmRTZWN0aW9uMQoJe3BhZ2U6V29yZFNlY3Rpb24xO30KLS0+PC9z dHlsZT48IS0tW2lmIGd0ZSBtc28gOV0+PHhtbD4KPG86c2hhcGVkZWZhdWx0cyB2OmV4dD0zRCJl ZGl0IiBzcGlkbWF4PTNEIjEwMjYiIC8+CjwveG1sPjwhW2VuZGlmXS0tPjwhLS1baWYgZ3RlIG1z byA5XT48eG1sPgo8bzpzaGFwZWxheW91dCB2OmV4dD0zRCJlZGl0Ij4KPG86aWRtYXAgdjpleHQ9 M0QiZWRpdCIgZGF0YT0zRCIxIiAvPgo8L286c2hhcGVsYXlvdXQ+PC94bWw+PCFbZW5kaWZdLS0+ CjwvaGVhZD4KPGJvZHkgbGFuZz0zRCJFTi1VUyIgbGluaz0zRCJibHVlIiB2bGluaz0zRCJwdXJw bGUiPgo8ZGl2IGNsYXNzPTNEIldvcmRTZWN0aW9uMSI+CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+ PHNwYW4gc3R5bGU9M0QiZm9udC1zaXplOjguNXB0O2ZvbnQtZmFtaWx5OiZxdW90O0hlbD0KdmV0 aWNhJnF1b3Q7LCZxdW90O3NhbnMtc2VyaWYmcXVvdDsiPkhlbGxvIG9WaXJ0IGd1cnUgb3V0IHRo ZXJlOjxicj4KPGJyPgpJIG5vdGljZSBvdXIgb1ZpcnQgZW5naW5lIHBvc3RncmVzIGRiIHNpemUg aXMgZ3Jvd2luZyBxdWl0ZSBmYXN0IGZvciBwYXN0IGM9Cm91cGxlIG9mIG1vbnRocy4gJm5ic3A7 SSBjaGVja2VkIHRoZSBkYXRhYmFzZSBzaXplLiAmbmJzcDtGb3VuZCB0aGF0IG91ciBvdj0KaXJ0 X2VuZ2luZV9oaXN0b3J5IGlzIDczR0IgaW4gc2l6ZS4gJm5ic3A7PGJyPgo8YnI+Cjxicj4KZW5n aW5lPTNEIyBcY29ubmVjdCBvdmlydF9lbmdpbmVfaGlzdG9yeTxicj4KWW91IGFyZSBub3cgY29u bmVjdGVkIHRvIGRhdGFiYXNlICZxdW90O292aXJ0X2VuZ2luZV9oaXN0b3J5JnF1b3Q7IGFzIHVz ZXIgPQomcXVvdDtwb3N0Z3JlcyZxdW90Oy48YnI+Cm92aXJ0X2VuZ2luZV9oaXN0b3J5PTNEIyBT RUxFQ1QgcGdfc2l6ZV9wcmV0dHkoIHBnX2RhdGFiYXNlX3NpemUoIGN1cnJlbnRfZD0KYXRhYmFz ZSgpICkgKSBBcyBodW1hbl9zaXplPGJyPgombmJzcDsmbmJzcDsmbmJzcDssIHBnX2RhdGFiYXNl X3NpemUoIGN1cnJlbnRfZGF0YWJhc2UoKSApIEFzIHJhd19zaXplOzxicj4KaHVtYW5fc2l6ZSB8 ICZuYnNwO3Jhd19zaXplPGJyPgotLS0tLS0tLS0tLS0mIzQzOy0tLS0tLS0tLS0tLS08YnI+Cjcz IEdCICZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwO3wgNzg0NDQyMTMzNjg8YnI+CigxIHJv dyk8YnI+Cjxicj4KPGJyPgpCcmllZiBjaGVjayB0aGUgcmVjb3JkcywgdGhlcmUgYXJlIGVudHJp ZXMgZGF0ZWQgYmFjayAyMDE0LiAmbmJzcDs8YnI+Cjxicj4KSSB3YW50IHRvIHNlZSBpZiB0aGVy ZSBpcyBhIHNhZmUgd2F5IHRvIGFyY2hpdmUgYW5kIHJlbW92ZSBzb21lIG9mIHRoZSBvbGRlPQpy IHJlY29yZHM/PGJyPgo8YnI+ClRoYW5rcyw8YnI+CkVyaWM8L3NwYW4+PG86cD48L286cD48L3A+ CjxwIGNsYXNzPTNEIk1zb05vcm1hbCI+PHNwYW4gc3R5bGU9M0QiZm9udC1zaXplOjExLjBwdDtm b250LWZhbWlseTomcXVvdDtDYT0KbGlicmkmcXVvdDssJnF1b3Q7c2Fucy1zZXJpZiZxdW90OyI+ PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPgo8L2Rpdj4KPC9ib2R5Pgo8L2h0bWw+CgotLV8w MDBfMmFkMmU5MjllZGQwNGVmNGE5MjM4ODdlMGM5YWI4MDRNU0VYMDRGUkE5Y29ycHNvbHZpYW5z Y18tLQo= --===============6471052655868016099==--