how to reduce Xidgenlock wait event

Hi Team, We have been observing XidGenlock wait in our transaction. This leeads some perofmrance issue in our product. We have heavyly commit product but still we are not getting such wait during the time. We have increase our load to double and then it start getting it. I have check the transa

Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

On Tue, 2021-08-24 at 06:21 +, Li EF Zhang wrote: > dict_int is trusted extension in pg13. After creating dict_int extension with > unprivileged user, ALTER TEXT SEARCH DICTIONARY intdict ((MAXLEN = 7) failed. >   > admin=> ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 7); > ERROR:  must be ow

Re: Make bloom extension trusted, but can not drop with normal user

On Sat, Aug 21, 2021 at 1:09 PM Mladen Gogala wrote: > Why do you think that the normal user should be allowed to drop > extensions? The documentation. https://www.postgresql.org/docs/current/sql-createextension.html "This configuration gives the calling user the right to drop the extension,

Re: Make bloom extension trusted, but can not drop with normal user

On Fri, Aug 20, 2021 at 6:26 AM Tom Lane wrote: > "Li EF Zhang" writes: > > Since pg13 support trusted extension, so I changed control file of bloom > and make it trusted. > > The fact that you can edit the file that way doesn't make it a supported > case. > > Why does that matter here though?

Re: Make bloom extension trusted, but can not drop with normal user

"David G. Johnston" writes: > On Fri, Aug 20, 2021 at 6:26 AM Tom Lane wrote: >> "Li EF Zhang" writes: >>> Since pg13 support trusted extension, so I changed control file of bloom >>> and make it trusted. >> The fact that you can edit the file that way doesn't make it a supported >> case. > Wh

Re: Make bloom extension trusted, but can not drop with normal user

On 8/24/21 7:40 AM, David G. Johnston wrote: On Fri, Aug 20, 2021 at 6:26 AM Tom Lane > wrote: "Li EF Zhang" mailto:bjzha...@cn.ibm.com>> writes: > Since pg13 support trusted extension, so I changed control file of bloom and make it trusted. The fact

Re: Make bloom extension trusted, but can not drop with normal user

On Tue, Aug 24, 2021 at 8:17 AM Adrian Klaver wrote: > > To me the issue is that the extension was modified to trusted by an end > user not the extension author. I gotta believe there is more to the > trusted then a flag in the control file. It would not be surprising to > me that an ad hoc modif

RE: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

Thanks for your answer. My doubt is that since an ordinary user creates the extension, shouldn't be this user the owner of the objects created within the extension?   - Original message -From: "Laurenz Albe" To: "Li EF Zhang" , pgsql-general@lists.postgresql.orgCc:Subject: [EXTERNAL] Re: Ca

Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

On Tue, Aug 24, 2021 at 8:51 PM Li EF Zhang wrote: > Thanks for your answer. My doubt is that since an ordinary user creates > the extension, shouldn't be this user the owner of the objects created > within the extension? > While that is a possible implementation choice, that isn't what was chos

Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

"David G. Johnston" writes: > On Tue, Aug 24, 2021 at 8:51 PM Li EF Zhang wrote: >> Thanks for your answer. My doubt is that since an ordinary user creates >> the extension, shouldn't be this user the owner of the objects created >> within the extension? > While that is a possible implementation

Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

On Tue, Aug 24, 2021 at 9:20 PM Tom Lane wrote: > "David G. Johnston" writes: > > On Tue, Aug 24, 2021 at 8:51 PM Li EF Zhang wrote: > >> Thanks for your answer. My doubt is that since an ordinary user creates > >> the extension, shouldn't be this user the owner of the objects created > >> with

RE: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

Got it! Thank you all very much!   - Original message -From: "David G. Johnston" To: "Tom Lane" Cc: "Li EF Zhang" , "Laurenz Albe" , "pgsql-generallists.postgresql.org" Subject: [EXTERNAL] Re: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_intDate: Wed, Aug 25, 2021 1