Re: Missing query plan for auto_explain.

2022-09-09 Thread Maxim Boguk
On Thu, Sep 8, 2022 at 1:18 PM Matheus Martin wrote: > We do have JIT enabled `jit=on` with `jit_above_cost=10`. > > I am sorry but I don't quite understand what role JIT plays in > this situation with `auto_explain`. Could you please elaborate on that? > > In your log - time spent during the

Re: ERROR: cache lookup failed for user mapping 476444

2022-09-09 Thread Shanker Singh
Hi Tom, Thank you very much for the info. Pg-depend did had an entry for the above object. After deleting the entry the drop extension worked fine. Thank you very much for the help. Regards, Shanker Sent from my iPhone > On Sep 9, 2022, at 8:10 AM, Tom Lane wrote: > > shanker singh writes:

Re: ERROR: cache lookup failed for user mapping 476444

2022-09-09 Thread Tom Lane
shanker singh writes: > I am trying to delete an extension db2_fdw but getting  > ERROR:  cache lookup failed for user mapping 476444 Hmm, seems like there must be a pg_depend entry claiming that that user mapping depends on the extension; which it shouldn't, but ... Is there a pg_depend row ha

Re: ERROR: cache lookup failed for user mapping 476444

2022-09-09 Thread shanker singh
Hi TEAM, I am trying to delete an extension db2_fdw but getting  ERROR:  cache lookup failed for user mapping 476444   Is there any solution or workaround for this error.   Thanks and regards, Shanker   American Express made the following annotations "This message and