nt: 14 December 2017 16:13
> To: Nicola Contu
> Cc: Rene Romero Benavides ; pgsql-general@lists.
> postgresql.org; Alessandro Aste
> Subject: Re: pgstattuple free_percent to high
>
> Greetings Nicola,
>
> * Nicola Contu (nicola.co...@gmail.com) wrote:
> > I think tuning
]
Sent: 14 December 2017 16:13
To: Nicola Contu
Cc: Rene Romero Benavides ;
pgsql-general@lists.postgresql.org; Alessandro Aste
Subject: Re: pgstattuple free_percent to high
Greetings Nicola,
* Nicola Contu (nicola.co...@gmail.com) wrote:
> I think tuning the autovacuum settings may in
Greetings Nicola,
* Nicola Contu (nicola.co...@gmail.com) wrote:
> I think tuning the autovacuum settings may increase performances and remove
> dead_tuples but as far as I know, the autovacuum runs a vacuum analyze.
> The vacuum analyze won't touch the free_percent of the table.
That's not entir
Hi Rene,
thanks for you reply.
I think tuning the autovacuum settings may increase performances and remove
dead_tuples but as far as I know, the autovacuum runs a vacuum analyze.
The vacuum analyze won't touch the free_percent of the table.
So I'm trying to find a way to adjust the free percent f
Check for long running transactions modifying (update, insert) on those
tables ,using pg_stat_activity.
Tweak these storage parameters for such tables:
autovacuum_vacuum_cost_delay : decrease it (the autovacuum daemon goes to
sleep less often )
autovacuum_vacuum_threshold : decrease it (to trigger
Hello,
We are running postgres 9.6.6 on centos 7.
We have a large DB (180GB) with about 1200 tables.
We have autovacuum set with default values and we are seeing that for some
tables the free percent goes really high (51%) and we need to daily full
vacuum those tables.
dbanme=# SELECT * FROM pgs
