{"id":9773,"date":"2016-01-04T16:21:31","date_gmt":"2016-01-05T00:21:31","guid":{"rendered":"http:\/\/vspherestorage.com\/?p=9773"},"modified":"2016-01-04T16:24:03","modified_gmt":"2016-01-05T00:24:03","slug":"how-to-reindex-the-vra7-appliance-database","status":"publish","type":"post","link":"https:\/\/vspherestorage.com\/?p=9773","title":{"rendered":"How to reindex the vRA7 Appliance Database"},"content":{"rendered":"<p>How to reindex the vRA7 Appliance Database<\/p>\n<p><a href='http:\/\/bit.ly\/1PcbarW' target='_blank'><img src='https:\/\/d3utlhu53nfcwz.cloudfront.net\/171901\/cdnImage\/article\/bb5ddb05-3a59-4f61-84ae-8abd8fe7de27\/?size=Box320'><\/a><\/p>\n<h4><a href='http:\/\/bit.ly\/1PcbarW' style='text-decoration: none;' target='_blank'>How to reindex the vRA7 Appliance Database<\/a><\/h4>\n<p>The vRealize Automation 7 appliance provides the UI and portal functionality for vRA (among other things). Behind the scenes it is running a vPostgres database to store information about approvals, catalog items and some logging. Over time the database tables can become fragmented and impact performance of the portal. Always Continue reading ?<\/p>\n<hr \/>\n<p><a href='http:\/\/advocacy.vmware.com' target='_blank'>VMware Advocacy<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to reindex the vRA7 Appliance Database How to reindex the vRA7 Appliance Database The vRealize Automation 7 appliance provides the UI and portal functionality for vRA (among other things). Behind the scenes it is running a vPostgres database to store information about approvals, catalog items and some logging. Over time the database tables can [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[12],"tags":[],"class_list":["post-9773","post","type-post","status-publish","format-standard","hentry","category-vmware-advocacy"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4m26N-2xD","jetpack-related-posts":[{"id":3180,"url":"https:\/\/vspherestorage.com\/?p=3180","url_meta":{"origin":9773,"position":0},"title":"Schedule automated backups of VCSA 6.0&#8230;","author":"Mostafa Khalil","date":"10 years ago","format":false,"excerpt":"Schedule automated backups of VCSA 6.0 vPostgres embedded database to Amazon S3Schedule automated backups of VCSA 6.0...A couple of weeks back, I had received a question around backing up and restoring the Embedded vPostgres Database found within the new vCenter Server Appliance (VCSA) 6.0. At the time, the only thing\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15102,"url":"https:\/\/vspherestorage.com\/?p=15102","url_meta":{"origin":9773,"position":1},"title":"Getting Started with Data Services Manager 2.0&#8230;","author":"Mostafa Khalil","date":"10 years ago","format":false,"excerpt":"Getting Started with Data Services Manager 2.0 \u2013 Part 3: Deploy PostgreSQLGetting Started with Data Services Manager 2.0...So far, we have seen how to create an infrastructure policy and how to configure the DSM Provider appliance. In this third post in the series, I will show you how to deploy\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15116,"url":"https:\/\/vspherestorage.com\/?p=15116","url_meta":{"origin":9773,"position":2},"title":"Getting Started with Data Services Manager 2.0&#8230;","author":"Mostafa Khalil","date":"10 years ago","format":false,"excerpt":"Getting Started with Data Services Manager 2.0 \u2013 Part 3: Deploy PostgreSQLGetting Started with Data Services Manager 2.0...So far, we have seen how to create an infrastructure policy and how to configure the DSM Provider appliance. In this third post in the series, I will show you how to deploy\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15130,"url":"https:\/\/vspherestorage.com\/?p=15130","url_meta":{"origin":9773,"position":3},"title":"Getting Started with Data Services Manager 2.0&#8230;","author":"Mostafa Khalil","date":"10 years ago","format":false,"excerpt":"Getting Started with Data Services Manager 2.0 \u2013 Part 3: Deploy PostgreSQLGetting Started with Data Services Manager 2.0...So far, we have seen how to create an infrastructure policy and how to configure the DSM Provider appliance. In this third post in the series, I will show you how to deploy\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15144,"url":"https:\/\/vspherestorage.com\/?p=15144","url_meta":{"origin":9773,"position":4},"title":"Getting Started with Data Services Manager 2.0&#8230;","author":"Mostafa Khalil","date":"10 years ago","format":false,"excerpt":"Getting Started with Data Services Manager 2.0 \u2013 Part 3: Deploy PostgreSQLGetting Started with Data Services Manager 2.0...So far, we have seen how to create an infrastructure policy and how to configure the DSM Provider appliance. In this third post in the series, I will show you how to deploy\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":15158,"url":"https:\/\/vspherestorage.com\/?p=15158","url_meta":{"origin":9773,"position":5},"title":"Getting Started with Data Services Manager 2.0&#8230;","author":"Mostafa Khalil","date":"10 years ago","format":false,"excerpt":"Getting Started with Data Services Manager 2.0 \u2013 Part 3: Deploy PostgreSQLGetting Started with Data Services Manager 2.0...So far, we have seen how to create an infrastructure policy and how to configure the DSM Provider appliance. In this third post in the series, I will show you how to deploy\u2026","rel":"","context":"Similar post","block_context":{"text":"Similar post","link":""},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/vspherestorage.com\/index.php?rest_route=\/wp\/v2\/posts\/9773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vspherestorage.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vspherestorage.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vspherestorage.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vspherestorage.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9773"}],"version-history":[{"count":1,"href":"https:\/\/vspherestorage.com\/index.php?rest_route=\/wp\/v2\/posts\/9773\/revisions"}],"predecessor-version":[{"id":9774,"href":"https:\/\/vspherestorage.com\/index.php?rest_route=\/wp\/v2\/posts\/9773\/revisions\/9774"}],"wp:attachment":[{"href":"https:\/\/vspherestorage.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vspherestorage.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vspherestorage.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}