Horton

Re: Refresh Publication takes hours and doesn´t finish

Marcos Pegoraro <marcos@f10.com.br>

View thread View on postgr.es
From: PegoraroF10 <marcos@f10.com.br>
To: pgsql-general@postgresql.org
Date: 2019-05-21T17:16:47Z
Lists: pgsql-hackers, pgsql-general 
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.

I found some people talking that I need to initdb, but initdb means recreate
entirely my database or just reinstall my postgres server ?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

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.