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
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 fo
16:37, Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> a écrit :
> >
> > 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 th
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 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".
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 da
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
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
