Re: Londiste 3 pgq events_1_1 table huge

From: Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com>
To:
Cc: PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Londiste 3 pgq events_1_1 table huge
Date: 2016-05-20 13:19:29
Message-ID: 573F0EE1.3040609@griensu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

El 19/05/16 a las 12:39, Saiful Muhajir escribió:
> This has happened to us where we have dead or unmanaged consumer. Turns
> out londiste is keeping the event even if the consumer is unreachable.
> This is to ensure that the consumer gets what it should.
>
> To clean this up, delete the unused/dead consumer, with qadmin or
> manually if necessary. The table won't be deleted immediately though. We
> have to restart pgqd and workers and wait for two days.
>

Thanks Rene and Saiful, I found two unused consumers, but after
"unregister consumer ...." those aren't deleted, what can I do to remove
them?.

--
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leonardo M. Ramé 2016-05-20 13:29:20 Re: Londiste 3 pgq events_1_1 table huge
Previous Message David G. Johnston 2016-05-20 13:09:25 Re: PostgreSql Doubts