{"id":1957,"date":"2018-02-26T13:42:56","date_gmt":"2018-02-26T18:42:56","guid":{"rendered":"https:\/\/vortexbird.com\/?p=1957"},"modified":"2024-11-14T04:45:09","modified_gmt":"2024-11-14T04:45:09","slug":"comando-de-postgres-vacuum","status":"publish","type":"post","link":"https:\/\/vortexbird.com\/en\/comando-de-postgres-vacuum\/","title":{"rendered":"Comando de Postgres VACUUM"},"content":{"rendered":"<p>Hola a Todos:<\/p>\n<p>El d\u00eda de hoy hablaremos del comando de Postgres VACUUM, seg\u00fan La documentaci\u00f3n de Postgres, este comando recupera el almacenamiento ocupado por las tuplas muertas. Estos significa que las tuplas que son eliminadas u obsoletas por actualizaci\u00f3n, no son eliminadas f\u00edsicamente de su tabla y persisten dentro del servidor.<\/p>\n<p>Esta es la sintaxis del comando:<\/p>\n<pre>VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]<\/pre>\n<p>VACUUM PUEDE RECIBIR LOS SIGUIENTES PARAMETROS<\/p>\n<ul>\n<li>FREEZE: Comando deprecado y se remover\u00e1 en versiones futuras<\/li>\n<li>FULL: Realiza una limpieza m\u00e1s completa pero bloquea las tablas al momento de la ejecuci\u00f3n<\/li>\n<li>VERBOSE: Imprime un reporte detallado por cada tabla<\/li>\n<li>ANALYZE: Actualiza las estad\u00edsticas de an\u00e1lisis para ejecutar las consultas m\u00e1s eficientes<\/li>\n<li>TABLA:Tabla la cual se va a limpiar, Por defecto son todas.<\/li>\n<li>Columna:Columna de la tabla a la cual se va a limpiar, Por defecto todas<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>Tambi\u00e9n podemos hacer Autovacuum que lo hablaremos en otro post\u2026<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hola a Todos: El d\u00eda de hoy hablaremos del comando de Postgres VACUUM, seg\u00fan La documentaci\u00f3n de Postgres, este comando &#8230; <a class=\"cz_readmore cz_readmore_no_icon\" href=\"https:\/\/vortexbird.com\/en\/comando-de-postgres-vacuum\/\"><span>Read more<\/span><\/a><\/p>","protected":false},"author":3,"featured_media":4596,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[66],"tags":[],"class_list":["post-1957","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Comando de Postgres VACUUM<\/title>\n<meta name=\"description\" content=\"El d\u00eda de hoy hablaremos del comando de Postgres VACUUM, seg\u00fan La documentaci\u00f3n de Postgres, este comando recupera el almacenamiento ocupado por las tuplas muertas. Estos significa que las tuplas que son eliminadas u obsoletas por actualizaci\u00f3n, no son eliminadas f\u00edsicamente de su tabla y persisten dentro del servidor\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vortexbird.com\/en\/comando-de-postgres-vacuum\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comando de Postgres VACUUM\" \/>\n<meta property=\"og:description\" content=\"El d\u00eda de hoy hablaremos del comando de Postgres VACUUM, seg\u00fan La documentaci\u00f3n de Postgres, este comando recupera el almacenamiento ocupado por las tuplas muertas. Estos significa que las tuplas que son eliminadas u obsoletas por actualizaci\u00f3n, no son eliminadas f\u00edsicamente de su tabla y persisten dentro del servidor\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vortexbird.com\/en\/comando-de-postgres-vacuum\/\" \/>\n<meta property=\"og:site_name\" content=\"Vortexbird\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-26T18:42:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-14T04:45:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vortexbird.com\/wp-content\/uploads\/2018\/07\/JDK-y-JAVA_HOME-en-Ubuntu.png\" \/>\n\t<meta property=\"og:image:width\" content=\"682\" \/>\n\t<meta property=\"og:image:height\" content=\"389\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"mmunoz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"mmunoz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/\"},\"author\":{\"name\":\"mmunoz\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#\\\/schema\\\/person\\\/aba580e87954c3ea4fd42a2a30f3fba4\"},\"headline\":\"Comando de Postgres VACUUM\",\"datePublished\":\"2018-02-26T18:42:56+00:00\",\"dateModified\":\"2024-11-14T04:45:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/\"},\"wordCount\":161,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/vortexbird.com\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/JDK-y-JAVA_HOME-en-Ubuntu.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/\",\"url\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/\",\"name\":\"Comando de Postgres VACUUM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/vortexbird.com\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/JDK-y-JAVA_HOME-en-Ubuntu.png\",\"datePublished\":\"2018-02-26T18:42:56+00:00\",\"dateModified\":\"2024-11-14T04:45:09+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#\\\/schema\\\/person\\\/aba580e87954c3ea4fd42a2a30f3fba4\"},\"description\":\"El d\u00eda de hoy hablaremos del comando de Postgres VACUUM, seg\u00fan La documentaci\u00f3n de Postgres, este comando recupera el almacenamiento ocupado por las tuplas muertas. Estos significa que las tuplas que son eliminadas u obsoletas por actualizaci\u00f3n, no son eliminadas f\u00edsicamente de su tabla y persisten dentro del servidor\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/#primaryimage\",\"url\":\"https:\\\/\\\/vortexbird.com\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/JDK-y-JAVA_HOME-en-Ubuntu.png\",\"contentUrl\":\"https:\\\/\\\/vortexbird.com\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/JDK-y-JAVA_HOME-en-Ubuntu.png\",\"width\":682,\"height\":389,\"caption\":\"image JDK y JAVA_HOME en Ubuntu\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/comando-de-postgres-vacuum\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/vortexbird.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comando de Postgres VACUUM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#website\",\"url\":\"https:\\\/\\\/vortexbird.com\\\/\",\"name\":\"Vortexbird\",\"description\":\"Desarrollo &aacute;gil de software\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/vortexbird.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/vortexbird.com\\\/#\\\/schema\\\/person\\\/aba580e87954c3ea4fd42a2a30f3fba4\",\"name\":\"mmunoz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/450e82e636f92e0d86751939551454e2cb102ab626b1ca22fde320fb38a81e91?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/450e82e636f92e0d86751939551454e2cb102ab626b1ca22fde320fb38a81e91?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/450e82e636f92e0d86751939551454e2cb102ab626b1ca22fde320fb38a81e91?s=96&d=mm&r=g\",\"caption\":\"mmunoz\"},\"url\":\"https:\\\/\\\/vortexbird.com\\\/en\\\/author\\\/mmunoz\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Comando de Postgres VACUUM","description":"El d\u00eda de hoy hablaremos del comando de Postgres VACUUM, seg\u00fan La documentaci\u00f3n de Postgres, este comando recupera el almacenamiento ocupado por las tuplas muertas. Estos significa que las tuplas que son eliminadas u obsoletas por actualizaci\u00f3n, no son eliminadas f\u00edsicamente de su tabla y persisten dentro del servidor","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vortexbird.com\/en\/comando-de-postgres-vacuum\/","og_locale":"en_US","og_type":"article","og_title":"Comando de Postgres VACUUM","og_description":"El d\u00eda de hoy hablaremos del comando de Postgres VACUUM, seg\u00fan La documentaci\u00f3n de Postgres, este comando recupera el almacenamiento ocupado por las tuplas muertas. Estos significa que las tuplas que son eliminadas u obsoletas por actualizaci\u00f3n, no son eliminadas f\u00edsicamente de su tabla y persisten dentro del servidor","og_url":"https:\/\/vortexbird.com\/en\/comando-de-postgres-vacuum\/","og_site_name":"Vortexbird","article_published_time":"2018-02-26T18:42:56+00:00","article_modified_time":"2024-11-14T04:45:09+00:00","og_image":[{"width":682,"height":389,"url":"https:\/\/vortexbird.com\/wp-content\/uploads\/2018\/07\/JDK-y-JAVA_HOME-en-Ubuntu.png","type":"image\/png"}],"author":"mmunoz","twitter_card":"summary_large_image","twitter_misc":{"Written by":"mmunoz","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/#article","isPartOf":{"@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/"},"author":{"name":"mmunoz","@id":"https:\/\/vortexbird.com\/#\/schema\/person\/aba580e87954c3ea4fd42a2a30f3fba4"},"headline":"Comando de Postgres VACUUM","datePublished":"2018-02-26T18:42:56+00:00","dateModified":"2024-11-14T04:45:09+00:00","mainEntityOfPage":{"@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/"},"wordCount":161,"commentCount":0,"image":{"@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/#primaryimage"},"thumbnailUrl":"https:\/\/vortexbird.com\/wp-content\/uploads\/2018\/07\/JDK-y-JAVA_HOME-en-Ubuntu.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/","url":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/","name":"Comando de Postgres VACUUM","isPartOf":{"@id":"https:\/\/vortexbird.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/#primaryimage"},"image":{"@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/#primaryimage"},"thumbnailUrl":"https:\/\/vortexbird.com\/wp-content\/uploads\/2018\/07\/JDK-y-JAVA_HOME-en-Ubuntu.png","datePublished":"2018-02-26T18:42:56+00:00","dateModified":"2024-11-14T04:45:09+00:00","author":{"@id":"https:\/\/vortexbird.com\/#\/schema\/person\/aba580e87954c3ea4fd42a2a30f3fba4"},"description":"El d\u00eda de hoy hablaremos del comando de Postgres VACUUM, seg\u00fan La documentaci\u00f3n de Postgres, este comando recupera el almacenamiento ocupado por las tuplas muertas. Estos significa que las tuplas que son eliminadas u obsoletas por actualizaci\u00f3n, no son eliminadas f\u00edsicamente de su tabla y persisten dentro del servidor","breadcrumb":{"@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/#primaryimage","url":"https:\/\/vortexbird.com\/wp-content\/uploads\/2018\/07\/JDK-y-JAVA_HOME-en-Ubuntu.png","contentUrl":"https:\/\/vortexbird.com\/wp-content\/uploads\/2018\/07\/JDK-y-JAVA_HOME-en-Ubuntu.png","width":682,"height":389,"caption":"image JDK y JAVA_HOME en Ubuntu"},{"@type":"BreadcrumbList","@id":"https:\/\/vortexbird.com\/comando-de-postgres-vacuum\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/vortexbird.com\/"},{"@type":"ListItem","position":2,"name":"Comando de Postgres VACUUM"}]},{"@type":"WebSite","@id":"https:\/\/vortexbird.com\/#website","url":"https:\/\/vortexbird.com\/","name":"Vortexbird","description":"Desarrollo &aacute;gil de software","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vortexbird.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/vortexbird.com\/#\/schema\/person\/aba580e87954c3ea4fd42a2a30f3fba4","name":"mmunoz","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/450e82e636f92e0d86751939551454e2cb102ab626b1ca22fde320fb38a81e91?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/450e82e636f92e0d86751939551454e2cb102ab626b1ca22fde320fb38a81e91?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/450e82e636f92e0d86751939551454e2cb102ab626b1ca22fde320fb38a81e91?s=96&d=mm&r=g","caption":"mmunoz"},"url":"https:\/\/vortexbird.com\/en\/author\/mmunoz\/"}]}},"_links":{"self":[{"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/posts\/1957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/comments?post=1957"}],"version-history":[{"count":0,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/posts\/1957\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/media\/4596"}],"wp:attachment":[{"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/media?parent=1957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/categories?post=1957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vortexbird.com\/en\/wp-json\/wp\/v2\/tags?post=1957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}