RE: pg_publication_tables show dropped columns

On Tuesday, September 6, 2022 11:13 AM Tom Lane  wrote:
> 
> Jaime Casanova  writes:
> > Just trying the new column/row filter on v15, I found this issue that
> > could be replicated very easily.
> 
> Bleah.  Post-beta4 catversion bump, here we come.

Oh, Sorry for the miss.

> > This could be solved by adding a "NOT attisdropped", simple patch
> > attached.
> 
> That view seems quite inefficient as written --- I wonder if we can't do better by
> nuking the join-to-unnest business and putting the restriction in a WHERE
> clause on the pg_attribute scan.
> The query plan that you get for it right now is certainly awful.

I agree and try to improve the query as suggested.

Here is the new version patch.
I think the query plan and cost looks better after applying the patch.

Best regards,
Hou zj