Re: How to add a new operator for parser?

> 2023年8月6日 13:18，Julien Rouhaud 写道： > > On Sun, 6 Aug 2023, 12:34 jacktby jacktby, > wrote: >> I’m trying to add a new operator for my pg application like greater_equals >> called “<~>", how many files I need to >> modify and how to do it? Can you give me an

logical decoding issue with concurrent ALTER TYPE

Hi all, A colleague Drew Callahan (in CC) has discovered that the logical decoding doesn't handle syscache invalidation messages properly that are generated by other transactions. Here is example (I've attached a patch for isolation test), -- Setup CREATE TYPE comp AS (f1 int, f2 text); CREATE

Re: How to add a new operator for parser?

On Sun, 6 Aug 2023, 12:34 jacktby jacktby, wrote: > I’m trying to add a new operator for my pg application like greater_equals > called “<~>", how many files I need to > modify and how to do it? Can you give me an example? > you can look at some contrib for some examples of custom operator (and

How to add a new operator for parser?

I’m trying to add a new operator for my pg application like greater_equals called “<~>", how many files I need to modify and how to do it? Can you give me an example?

Re: POC, WIP: OR-clause support for indexes

On Thu, Aug 3, 2023 at 12:47 PM Alena Rybakina wrote: > It's all right. I understand your position) Okay, good to know. :-) > I also agree to try to find other optimization cases and generalize them. Good idea. Since the real goal is to "get a working flow of information", the practical value

Re: PG 16 draft release notes ready

On Thu, May 18, 2023 at 04:49:47PM -0400, Bruce Momjian wrote: > https://momjian.us/pgsql_docs/release-16.html > > > > > Restrict the privileges of CREATEROLE roles (Robert Haas) > > > > Previously roles with CREATEROLE privileges could change many aspects of any > non-superuser

Re: initdb caching during tests

Hi, On 2023-08-05 16:58:38 -0400, Tom Lane wrote: > Andres Freund writes: > > Times for running all tests under meson, on my workstation (20 cores / 40 > > threads): > > > cassert build -O2: > > > Before: > > real0m44.638s > > user7m58.780s > > sys 2m48.773s > > > After: > >

Re: initdb caching during tests

Andres Freund writes: > Times for running all tests under meson, on my workstation (20 cores / 40 > threads): > cassert build -O2: > Before: > real 0m44.638s > user 7m58.780s > sys 2m48.773s > After: > real 0m38.938s > user 2m37.615s > sys 2m0.570s Impressive results. Even though

ci: Improve macos startup using a cached macports installation

Hi, We have some issues with CI on macos and windows being too expensive (more on that soon in a separate email). For macos most of the obviously wasted time is spent installing packages with homebrew. Even with the package downloads being cached, it takes about 1m20s to install them. We can't

initdb caching during tests

Hi, We have some issues with CI on macos and windows being too expensive (more on that soon in a separate email), which reminded me of this thread (with original title: [1]) I've attached a somewhat cleaned up version of the patch to cache initdb across runs. The results are still fairly

Re: cataloguing NOT NULL constraints

On Sat, 5 Aug 2023 at 18:37, Alvaro Herrera wrote: > > Yeah, something like that. However, if the child had a NOT NULL > constraint of its own, then it should not be deleted when the > PK-on-parent is, but merely marked as no longer inherited. (This is > also what happens with a straight NOT

Re: cataloguing NOT NULL constraints

On 2023-Aug-05, Dean Rasheed wrote: > Hmm, thinking about this some more, I think this might be the wrong > approach to fixing the original problem. I think it was probably OK > that the NOT NULL constraint on the child was marked as inherited, but > I think what should have happened is that

Re: cataloguing NOT NULL constraints

On Fri, 4 Aug 2023 at 19:10, Alvaro Herrera wrote: > > On 2023-Jul-28, Alvaro Herrera wrote: > > > To avoid that, one option would be to make this NN constraint > > undroppable ... but I don't see how. One option might be to add a > > pg_depend row that links the NOT NULL constraint to its PK

Re: brininsert optimization opportunity

Created an entry for the Sep CF: https://commitfest.postgresql.org/44/4484/ Regards, Soumyadeep (VMware) On Sat, Jul 29, 2023 at 9:28 AM Soumyadeep Chakraborty wrote: > > Attached v4 of the patch, rebased against latest HEAD. > > Regards, > Soumyadeep (VMware)