Horton

Re: Refresh Publication takes hours and doesn´t finish

Fabrízio de Royes Mello <fabrizio@timbira.com.br>

View thread View on postgr.es
From: Fabrízio de Royes Mello <fabrizio@timbira.com.br>
To: PegoraroF10 <marcos@f10.com.br>
Cc: Postgres General <pgsql-general@postgresql.org>
Date: 2019-05-21T17:27:01Z
Lists: pgsql-hackers, pgsql-general 
Em ter, 21 de mai de 2019 às 14:17, PegoraroF10 <marcos@f10.com.br>
escreveu:
>
> Restart Postgres means exactly what ? We tried just restart the service
but
> we tried to refresh publication the old view was used because it took
2hours
> and gave us a timeout.
>

As I said before to change system catalog you should set
"allow_system_table_mods=on" and restart PostgreSQL service.

After that you'll able to recreate the "pg_catalog.pg_publication_tables"
system view. (You can use the Tom's suggestion using LATERAL)

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Commits

  1. Fix O(N^2) performance issue in pg_publication_tables view.

  2. Clean up the behavior and API of catalog.c's is-catalog-relation tests.