public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Cocam' server <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Need help to make space on my database
Date: Mon, 29 Apr 2024 12:28:25 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAJyHkoh9X-nk2ebxWgBTgG+KLk84jNHazdyUA7ZEK3tiu4xuVw@mail.gmail.com>
References: <CAJyHkohEM4cG==cqWwLYTLzaMV-XWUVF0yb9AYfZSwVu_fO=vg@mail.gmail.com>
<[email protected]>
<CAJyHkoh6OjQ-M6BvFV6c=XRErWB1hVsimPaVo+X8qzxHrkiaiQ@mail.gmail.com>
<[email protected]>
<CAJyHkoixrJB=NOY3DwgBD7ZM1_nsJkSzgd9CZ97dejJzmvSdCQ@mail.gmail.com>
<[email protected]>
<CAJyHkoh9X-nk2ebxWgBTgG+KLk84jNHazdyUA7ZEK3tiu4xuVw@mail.gmail.com>
On 4/29/24 08:51, Cocam' server wrote:
> > Did the above work for each table?
> Yes, except for the biggest table
>
> > Have you done something like?:
> >
> > select relname, n_dead_tup from pg_stat_all_tables where relname =
> > '<table_name>';
>
> I hadn't thought of that, but it seems that some tables have dead tuples
>
You have something against providing actual numbers?
The point is there is really nothing to be gained by doing VACUUM FULL
if the dead tuples are some small percentage of the tables.
--
Adrian Klaver
[email protected]
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]
Subject: Re: Need help to make space on my database
In-Reply-To: <[email protected]>
* 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