{"version":"1.0","provider_name":"Database Tutorials","provider_url":"https:\/\/dbtut.com","author_name":"Vaibhav Krishna","author_url":"https:\/\/dbtut.com\/index.php\/author\/vaibhavkrishna\/","title":"PostGre SQL Database Maintenance - Database Tutorials","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"hnH6ok2dyX\"><a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/database-maintenance\/\">PostGre SQL Database Maintenance<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/dbtut.com\/index.php\/2018\/08\/14\/database-maintenance\/embed\/#?secret=hnH6ok2dyX\" width=\"600\" height=\"338\" title=\"&#8220;PostGre SQL Database Maintenance&#8221; &#8212; Database Tutorials\" data-secret=\"hnH6ok2dyX\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/dbtut.com\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"PostgreSQL, like any database software, requires that certain\u00a0tasks be performed regularly to achieve optimum performance.\u00a0The tasks discussed here are required, but they are repetitive in\u00a0nature and can easily be automated using standard tools such\u00a0as cron scripts or Windows&#8217; Task Scheduler. It is the database\u00a0administrator&#8217;s responsibility to set up appropriate scripts, and\u00a0to check that they execute &hellip;"}