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 =
> '';
I hadn't thought of that, but it seems that some tables have dead tupl
On Mon, 2024-04-29 at 15:45 +0200, Cocam' server wrote:
> 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
> 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 =
> '';
I hadn't thought of that, but it seems that some tables have dead tuples
Le lun. 29 avr. 2024 à 17:34, Adrian Kl
On 4/29/24 08:04, Cocam' server wrote:
When replying use Reply All to include the mailing list
Ccing list
> How much current free space do you have available on the disk?
as we speak, I only have 6 GB available on the machine running the server
> Did you VACUUM FULL a table at a time or all
On 4/29/24 07:33, Cocam' server wrote:
Please reply to list also
Ccing list
No, the aim is also to reallocate free space to the system for the other
tasks it performs.(That's why I said I'd like it returned to the OS)
You led with:
"I need help to make space on my database".
How much curren
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
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 sever
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 ba
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
