public inbox for [email protected]
help / color / mirror / Atom feedFrom: Kashif Zeeshan <[email protected]>
To: Adrian Klaver <[email protected]>
Cc: Cocam' server <[email protected]>
Cc: [email protected]
Subject: Re: Need help to make space on my database
Date: Mon, 29 Apr 2024 19:25:57 +0500
Message-ID: <CAAPsdhf9PWvmM5Jdg31D-oVX6XTshpn-HfmnT47ZUBWOebRUfw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJyHkohEM4cG==cqWwLYTLzaMV-XWUVF0yb9AYfZSwVu_fO=vg@mail.gmail.com>
<[email protected]>
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 PM Adrian Klaver <[email protected]>
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 several
> > GB in size. I used to use the VACUUM FULL VERBOSE command; but now, this
> > command is too greedy in free space to be used and I'm looking for a way
> > 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
> [email protected]
>
>
>
>
view thread (7+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Need help to make space on my database
In-Reply-To: <CAAPsdhf9PWvmM5Jdg31D-oVX6XTshpn-HfmnT47ZUBWOebRUfw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox