MIME-Version: 1.0
References: <CAJyHkohEM4cG==cqWwLYTLzaMV-XWUVF0yb9AYfZSwVu_fO=vg@mail.gmail.com>
 <5874a355-51fb-4fa3-acf4-df81a6d5b5f0@aklaver.com>
In-Reply-To: <5874a355-51fb-4fa3-acf4-df81a6d5b5f0@aklaver.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Mon, 29 Apr 2024 19:25:57 +0500
Message-ID: <CAAPsdhf9PWvmM5Jdg31D-oVX6XTshpn-HfmnT47ZUBWOebRUfw@mail.gmail.com>
Subject: Re: Need help to make space on my database
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: "Cocam' server" <cocamserver@gmail.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d67c3c06173d0826"
Archived-At: <https://www.postgresql.org/message-id/CAAPsdhf9PWvmM5Jdg31D-oVX6XTshpn-HfmnT47ZUBWOebRUfw%40mail.gmail.com>
Precedence: bulk

--000000000000d67c3c06173d0826
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Please run VACUUM with ANALYZE option that will also update the DB Stats.

Regards
Kashif Zeeshan
Bitnine Global

On Mon, Apr 29, 2024 at 7:19=E2=80=AFPM Adrian Klaver <adrian.klaver@aklave=
r.com>
wrote:

> On 4/29/24 06:45, Cocam' server wrote:
> > Hello.
> >
> > I need help to make space on my database. I have tables that are severa=
l
> > GB in size. I used to use the VACUUM FULL VERBOSE command; but now, thi=
s
> > command is too greedy in free space to be used and I'm looking for a wa=
y
> > to make free space (given back to the OS)
> >
> > Thanks in advance to everyone who responds
>
> Per
>
> https://www.postgresql.org/docs/current/sql-vacuum.html
>
> "VACUUM reclaims storage occupied by dead tuples. In normal PostgreSQL
> operation, tuples that are deleted or obsoleted by an update are not
> physically removed from their table; they remain present until a VACUUM
> is done. Therefore it's necessary to do VACUUM periodically, especially
> on frequently-updated tables.
>
> <...>
>
> Plain VACUUM (without FULL) simply reclaims space and makes it available
> for re-use. This form of the command can operate in parallel with normal
> reading and writing of the table, as an exclusive lock is not obtained.
> However, extra space is not returned to the operating system (in most
> cases); it's just kept available for re-use within the same table.
> "
>
> So a regular VACUUM should work if all you want to do is give the
> database the ability to recycle the vacuumed tuple space.
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
>
>
>

--000000000000d67c3c06173d0826
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Please run VACUUM with ANALYZE option that will also =
update the DB Stats.</div><div><br></div><div>Regards</div><div>Kashif Zees=
han</div><div>Bitnine Global<br></div></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Mon, Apr 29, 2024 at 7:19=E2=80=AF=
PM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com">adrian.kl=
aver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex">On 4/29/24 06:45, Cocam&#39; server wrote:<br>
&gt; Hello.<br>
&gt; <br>
&gt; I need help to make space on my database. I have tables that are sever=
al <br>
&gt; GB in size. I used to use the VACUUM FULL VERBOSE command; but now, th=
is <br>
&gt; command is too greedy in free space to be used and I&#39;m looking for=
 a way <br>
&gt; to make free space (given back to the OS)<br>
&gt; <br>
&gt; Thanks in advance to everyone who responds<br>
<br>
Per<br>
<br>
<a href=3D"https://www.postgresql.org/docs/current/sql-vacuum.html" rel=3D"=
noreferrer" target=3D"_blank">https://www.postgresql.org/docs/current/sql-v=
acuum.html</a><br>
<br>
&quot;VACUUM reclaims storage occupied by dead tuples. In normal PostgreSQL=
 <br>
operation, tuples that are deleted or obsoleted by an update are not <br>
physically removed from their table; they remain present until a VACUUM <br=
>
is done. Therefore it&#39;s necessary to do VACUUM periodically, especially=
 <br>
on frequently-updated tables.<br>
<br>
&lt;...&gt;<br>
<br>
Plain VACUUM (without FULL) simply reclaims space and makes it available <b=
r>
for re-use. This form of the command can operate in parallel with normal <b=
r>
reading and writing of the table, as an exclusive lock is not obtained. <br=
>
However, extra space is not returned to the operating system (in most <br>
cases); it&#39;s just kept available for re-use within the same table.<br>
&quot;<br>
<br>
So a regular VACUUM should work if all you want to do is give the <br>
database the ability to recycle the vacuumed tuple space.<br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
<br>
<br>
</blockquote></div>

--000000000000d67c3c06173d0826--