Home > mailing lists

[PATCH] Avoid open and lock the table Extendend Statistics (src/backend/commands/statscmds.c) - Mailing list pgsql-hackers

From	Ranier Vilela
Subject	[PATCH] Avoid open and lock the table Extendend Statistics (src/backend/commands/statscmds.c)
Date	February 14, 2022 00:21:38
Msg-id	CAEudQArkb3-nvzsNetQWVcK4P+JLW_ZZTjR1iChKfJhK_p9--w@mail.gmail.com Whole thread Raw
Responses	Re: [PATCH] Avoid open and lock the table Extendend Statistics (src/backend/commands/statscmds.c) (Andres Freund <andres@anarazel.de>)
List	pgsql-hackers

Hi,

Commit https://github.com/postgres/postgres/commit/6d554e3fcd6fb8be2dbcbd3521e2947ed7a552cb

has fixed the bug, but still has room for improvement.

Why open and lock the table Extended Statistics if it is not the owner.

Check and return to avoid this.

trivial patch attached.

regards,

Ranier Vilela

Attachment

avoid_open_and_lock_table_if_not_owner.patch

pgsql-hackers by date:

Previous

From: Tom Lane
Date: 14 February 2022, 00:05:38
Subject: Re: Mark all GUC variable as PGDLLIMPORT

Next

From: Andres Freund
Date: 14 February 2022, 00:23:16
Subject: Re: Adding CI to our tree