vacuum full come disco

From: Enrique Herrera Noya <enrique(dot)herreranoya(at)gmail(dot)com>
To: Ayuda <pgsql-es-ayuda(at)lists(dot)postgresql(dot)org>
Subject: vacuum full come disco
Date: 2024-04-29 21:20:41
Message-ID: b6e96914-350f-4e44-9781-a7a7d6307dd5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda


en otro servidor con postgresql 10.23, me percate que despues de borrar
tablas que no usan los de producción de datos,

no se habia efectuado un vacuum  hace rato,

lance un vacuum full verbose;

y sigue comiendo disco, no se supone que debe liberar disco en ves de
ocupar mas disco

nota: son como 900 tablas .....

originalmente la base pesaba 1.2T, ya esta ocupando 2.7T

Enrique Herrera Noya
--
+56 992303151
Red Hat Certified Engineer RHCE Nº100223072 (RH6.0)
Red Hat Certified System Administrato RHCSA Nº100223072 (RH6.0)
Red Hat Certified Technician (RHCT) Nº605010753835478 (RH5.0)
Novell Certified Linux Professional CLP 10
Red Hat Delivery Specialist -Container Platform Application Deployment I
Red Hat Delivery Specialist - Container Platform Administration I
RED HAT SPECIALIST
How to Sell Red Hat OpenShift for Infrastructure
How to Sell Red Hat OpenShift for Developers
Red Hat Sales Engineer Specialist - Container Platform
Red Hat Sales Engineer Specialist – Automation

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Mario González Troncoso 2024-04-29 21:29:57 Re: vacuum full come disco
Previous Message Enrique Herrera Noya 2024-04-29 21:15:41 Re: Migración de servidor postgresql