Re: Is a VACUUM or ANALYZE necessary after logical replication?

2024-06-16 Thread David G. Johnston
On Saturday, June 15, 2024, Koen De Groote wrote: > I've gone over all of https://www.postgresql.org/docs/current/logical- > replication.html and the only mentions of the word "index" I could find > was in relation to replica identity and examples of table definitions > showing primary key indexe

Re: Is a VACUUM or ANALYZE necessary after logical replication?

2024-06-15 Thread Achilleas Mantzios
Στις 16/6/24 02:13, ο/η Adrian Klaver έγραψε: On 6/15/24 15:55, Koen De Groote wrote: I've gone over all of https://www.postgresql.org/docs/current/logical-replication.html and the only mentions of the word "index" I could find

Re: Is a VACUUM or ANALYZE necessary after logical replication?

2024-06-15 Thread Adrian Klaver
On 6/15/24 15:55, Koen De Groote wrote: I've gone over all of https://www.postgresql.org/docs/current/logical-replication.html and the only mentions of the word "index" I could find was in relation to replica identity and examp

Is a VACUUM or ANALYZE necessary after logical replication?

2024-06-15 Thread Koen De Groote
I've gone over all of https://www.postgresql.org/docs/current/logical-replication.html and the only mentions of the word "index" I could find was in relation to replica identity and examples of table definitions showing primary key indexes. Nothing is said about indexes. Maybe for good reason, may