Le ven. 17 janv. 2025 à 18:12, Franjo Stipanovic a
écrit :
> Thank you, Guillaume, Tom.
>
> In that case, querying pg_stat_user_tables on replica for last_vacuum,
> last_autovacuum, last_analyze, and last_autoanalyze columns makes no sense?
> Those specific columns are not transferred from the ma
Thank you, Guillaume, Tom.
In that case, querying pg_stat_user_tables on replica for last_vacuum,
last_autovacuum, last_analyze, and last_autoanalyze columns makes no sense?
Those specific columns are not transferred from the master? The same goes
for n_* columns? Currently, on my replica, all tho
Hi,
Le ven. 17 janv. 2025 à 15:38, Franjo Stipanovic a
écrit :
> Question regarding autovacuum settings in a PostgreSQL streaming
> replication setup. Specifically, I am curious about whether it is possible
> (and advisable) to have different values for the following settings on the
> master and
Franjo Stipanovic writes:
> Question regarding autovacuum settings in a PostgreSQL streaming
> replication setup. Specifically, I am curious about whether it is possible
> (and advisable) to have different values for the following settings on the
> master and replica databases:
> - autovacuum_vacu
Question regarding autovacuum settings in a PostgreSQL streaming
replication setup. Specifically, I am curious about whether it is possible
(and advisable) to have different values for the following settings on the
master and replica databases:
- autovacuum_vacuum_scale_factor
- autovacuum_analyze_
