Re: Londiste 3 pgq events_1_1 table huge - Mailing list pgsql-general

From Leonardo M. Ramé
Subject Re: Londiste 3 pgq events_1_1 table huge
Date
Msg-id 573F0EE1.3040609@griensu.com
Whole thread Raw
In response to Re: Londiste 3 pgq events_1_1 table huge  (Saiful Muhajir <saifulmuhajir@gmail.com>)
Responses Re: Londiste 3 pgq events_1_1 table huge
List 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


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: PostgreSql Doubts
Next
From: Leonardo M. Ramé
Date:
Subject: Re: Londiste 3 pgq events_1_1 table huge