From: | Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com> |
---|---|
To: | PostgreSql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Londiste 3 pgq events_1_1 table huge |
Date: | 2016-05-19 11:43:00 |
Message-ID: | 573DA6C4.1090200@griensu.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
El 18/05/16 a las 19:03, Rene . escribió:
> Hi, Check for long running Idle in transaction sessions. Idle in transaction sessions may holding events table from cleaning itself up.
> If there is more then days long running idle in transaction sessions, kill them, event table should be cleaned automatically after that.
>
> "select pid,state, query_start from pg_stat_activity where state='idle in transaction';" for checking sessions.
>
> Rene
Thanks Rene, I found only one "idle in transaction" and it dates from
just a couple of minutes ago, so, the reason of huge event table must be
something else.
By looking at the event_1_1 table I found records from march, but
londiste3 status shows everything is already in sync:
nodo_master (root)
| Tables: 146/0/0
| Lag: 0s, Tick: 1112197
+--: node_esclavo (leaf)
Tables: 146/0/0
Lag: 0s, Tick: 1112197
So, what if I manually delete old events?.
Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877
From | Date | Subject | |
---|---|---|---|
Next Message | Rene . | 2016-05-19 13:00:44 | Re: Londiste 3 pgq events_1_1 table huge |
Previous Message | Alexey Bashtanov | 2016-05-19 11:10:49 | Re: first_value/last_value |