Re: autovacuum excesivo PostgreSQL 9.5

Hellmuth Vargas escribió:

> > Ahh, ¿no tendrás un standby con "feedback" activado que tiene una
> > transacción preparada, o un slot inactivo? Pega acá
> > select * from pg_stat_replication
>
>
> bd=# select * from pg_stat_replication
> bd-# ;
> -[ RECORD 1 ]----+------------------------------
> pid | 1892
> usesysid | 10
> usename | postgres
> application_name | walreceiver
> client_addr | 192.168.72.XX
> client_hostname |
> client_port | 46648
> backend_start | 2016-10-02 11:46:57.003511-05
> backend_xmin |
> state | streaming
> sent_location | 9/11E181C0
> write_location | 9/11E181C0
> flush_location | 9/11E181C0
> replay_location | 9/11E18090
> sync_priority | 0
> sync_state | async
> -[ RECORD 2 ]----+------------------------------
> pid | 2043
> usesysid | 10
> usename | postgres
> application_name | walreceiver
> client_addr | 10.72.73.YY
> client_hostname |
> client_port | 55716
> backend_start | 2016-10-02 11:48:07.38359-05
> backend_xmin |
> state | streaming
> sent_location | 9/11E181C0
> write_location | 9/11E181C0
> flush_location | 9/11E181C0
> replay_location | 9/11E18090
> sync_priority | 0
> sync_state | async

???

Según controldata que pasaste antes,
Latest checkpoint's REDO location: 1896/AB72AB00
No tiene ningún sentido que sent_location acá sea 9/11E181C0. ¿Estamos
hablando del mismo servidor?

> > select * from pg_replication_slots
> >
> > bd=# select * from pg_replication_slots;
> -[ RECORD 1 ]+---------------------
> slot_name | replica_calleXX_slot
> plugin |
> slot_type | physical
> datoid |
> database |
> active | t
> active_pid | 1892
> xmin | 8355084
> catalog_xmin |
> restart_lsn | 9/11FA3D18
> -[ RECORD 2 ]+---------------------
> slot_name | replica_local_slot
> plugin |
> slot_type | physical
> datoid |
> database |
> active | t
> active_pid | 2043
> xmin | 5463120
> catalog_xmin |
> restart_lsn | 9/11FA3D18

Ídem; además, el xmin es 8 millones que no está ni cerca del
Latest checkpoint's NextXID: 0/2021183943
(dos mil millones) que mostraste en controldata.

Wtf?

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda(at)postgresql(dot)org)
Para cambiar tu suscripción:
http://www.postgresql.org/mailpref/pgsql-es-ayuda