Feedback-ID: i76984098:Fastmail
Message-ID: <f23d538f-7dc1-4723-b6d9-fd589a58ad8b@aklaver.com>
Date: Mon, 29 Apr 2024 12:28:25 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Need help to make space on my database
To: Cocam' server <cocamserver@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
References: <CAJyHkohEM4cG==cqWwLYTLzaMV-XWUVF0yb9AYfZSwVu_fO=vg@mail.gmail.com>
 <5874a355-51fb-4fa3-acf4-df81a6d5b5f0@aklaver.com>
 <CAJyHkoh6OjQ-M6BvFV6c=XRErWB1hVsimPaVo+X8qzxHrkiaiQ@mail.gmail.com>
 <2fab499b-2f96-4b34-a4ea-4817c2414b4f@aklaver.com>
 <CAJyHkoixrJB=NOY3DwgBD7ZM1_nsJkSzgd9CZ97dejJzmvSdCQ@mail.gmail.com>
 <8f942f5d-9c35-427d-9c1f-18aa405a7b8d@aklaver.com>
 <CAJyHkoh9X-nk2ebxWgBTgG+KLk84jNHazdyUA7ZEK3tiu4xuVw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAJyHkoh9X-nk2ebxWgBTgG+KLk84jNHazdyUA7ZEK3tiu4xuVw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/f23d538f-7dc1-4723-b6d9-fd589a58ad8b%40aklaver.com>
Precedence: bulk

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
adrian.klaver@aklaver.com