| From: | CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG <yann(dot)convers(at)developpement-durable(dot)gouv(dot)fr> |
|---|---|
| To: | priyanka chatterjee <pc9926(at)gmail(dot)com>, MichaelDBA <MichaelDBA(at)sqlexec(dot)com> |
| Cc: | Jeremiah Bauer <jbauer(at)agristats(dot)com>, Mariel Cherkassky <mariel(dot)cherkassky(at)gmail(dot)com>, Vijaykumar Jain <vjain(at)opentable(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: [Junk released by User action] Re: [Junk released by User action] Re: [External] Postgres Database Disk Usage |
| Date: | 2019-02-11 07:44:06 |
| Message-ID: | 0a04024e-48d0-71c4-f952-7a093bb944d3@developpement-durable.gouv.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi,<br>
<br>
vaccum full don't deliver free space from files not in database.
Your files are in the same directory but postgres doesn't kows them.<br>
<br>
You must restore database and rename it, if you need to keep same
name.<br>
<br>
you can delete files without link in pg_database but it's more
dangerous if you make mistake.<br>
<br>
I have doing that to time last month on database of 300 GB.<br>
<br>
I think i have a bog between proxmox/postgres 9.6.11 and ubuntu
16.04 but i haven't found it<br>
<br>
<br>
<br>
<br>
<div class="moz-signature">
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 2.3 (Win32)">
<meta name="AUTHOR" content="dreal-ra">
<meta name="CREATED" content="20110608;16534339">
<meta name="CHANGEDBY" content="Yann CONVERS">
<meta name="CHANGED" content="20120220;8494106">
<meta name="CHANGEDBY" content="Yann CONVERS">
<meta name="CHANGEDBY" content="dreal-aura">
<meta name="CHANGEDBY" content="dreal-aura">
<meta name="CHANGEDBY" content="dreal-aura">
<style type="text/css">
<!--
@page { size: 21cm 29.7cm; margin: 2cm }
P { margin-bottom: 0.21cm }
-->
</style>
<pre><b>Yann Convers</b>
Gestionnaire de l'infrastructure, des référentiels et des outils<p>
<font color="#000000"><b>DREAL Auvergne-Rhône-Alpes</b></font></p>
<pre>Service Connaissance, Information, Développement Durable, Autorité Environnementale - Pole Système d Information Géographique
Tél : 04 26 28 67 89
courriel : <a href="mailto:yann(dot)convers(at)developpement-durable(dot)gouv(dot)fr">yann(dot)convers(at)developpement-durable(dot)gouv(dot)fr</a></pre>adresse de la boite d’unité : <a href="mailto:sig(dot)dreal-ara(at)developpement-durable(dot)gouv(dot)fr">boite unité</a>
<p>Pour toute commande interne de prestations, merci d utilisez le formulaire suivant : <a href="http://postgis-aura.projets.appli.i2/projects/demandes-de-prestations/issues/new">http://postgis-aura.projets.appli.i2/projects/demandes-de-prestations/issues/new</a></p>
<b>Adresse postale :</b> DREAL Auvergne-Rhône-Alpes, CIDDAE - SIG
69453 LYON CEDEX 06
<b>Adresse physique :</b> 5
place Jules Ferry (immeuble Lugdunum - métro Brotteaux) -
69006 Lyon
<b>Standard :</b> 04 26 28 60 00
<b>Liens :</b><a href="http://intra.dreal-rhone-alpes.i2/">Site
Intranet</a> <a href="http://www.auvergne-rhone-alpes.developpement-durable.gouv.fr/">Site
Internet</a>
<p style="margin-bottom: 0cm">
</p>
</pre>
</div>
<div class="moz-cite-prefix">Le 09/02/2019 à 05:08, > priyanka
chatterjee (par Internet, dépôt
<a class="moz-txt-link-abbreviated" href="mailto:pgsql-admin-owner+m63745-121812(at)lists(dot)postgresql(dot)org">pgsql-admin-owner+m63745-121812(at)lists(dot)postgresql(dot)org</a>) a écrit :<br>
</div>
<blockquote
cite="mid:CANnOdgZ-QrvQhA-YHUCHUq33FmxPbzOLivS92_=Ao5Rxkp3hHg(at)mail(dot)gmail(dot)com"
type="cite">
<div
style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">Vacuum
Full on the entire database after adding more free space, but
the size of the database is still significantly larger than the
sum of the objects in it.</div>
<div
style="font-family:Calibri,Arial,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)"></div>
</blockquote>
<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 3.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2019-02-11 11:16:10 | Re: [Junk released by User action] Re: [Junk released by User action] Re: [External] Postgres Database Disk Usage |
| Previous Message | CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG | 2019-02-11 07:33:05 | Re: Postgres Database Disk Usage |