Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?

Bryn Llewellyn writes: > I'm going to try to think like this: > The number of possible spellings of the names of keys in a JSON object is > some flavor of infinite. So including this in an object: > "k": null > really is saying something. It says that I do know about "k" and that yet I > have si

Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?

> david.g.johns...@gmail.com wrote: > > b...@yugabyte.com wrote: > >> declare >> j1 constant jsonb not null := '{"x": 42, "y": null}'; >> j2 constant jsonb not null := '{"x": 42 }'; >> ... >> (j1->>'y' is null) > > This produces a JSON Null which when asked

Re: '{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?

On Fri, Jun 3, 2022 at 6:41 PM Bryn Llewellyn wrote: > > > > > *declare j1 constant jsonb not null := '{"x": 42, "y": > null}'; j2 constant jsonb not null := '{"x": 42 }';* > > *(j1->>'y' is null) * > This produces a JSON Null which when asked for as a text da

'{"x": 42, "y": null}'::jsonb != '{"x": 42}'::jsonb ... Really?

Here’s the minimal testcase: do $body$ declare j1 constant jsonb not null := '{"x": 42, "y": null}'; j2 constant jsonb not null := '{"x": 42 }'; predicate_1 constant boolean not null := (j1->>'y' is null) AND (j2->>'y' is null); predicate_2 constant boolea

Re: Why password authentication failed for user "postgres"?

On Sat, 2022-06-04 at 06:32 +0800, BeginnerC wrote: > Hello everyone, > I am a newbie to the postgres,when I use the psql to connect to the > postgres,a error message printed: > These command list like this: > > psql -U postgres > Password for user postgres:postgres > postgreSQL: password authenti

Why password authentication failed for user "postgres"?

Hello everyone, I am a newbie to the postgres,when I use the psql to connect to the postgres,a error message printed: These command list like this: psql -U postgres Password for user postgres:postgres *postgreSQL: password authentication failed for user "postgres"* * * How to solve this problem

Re: Logically replicated table has no visible rows

On 5/31/22 11:46 AM, Jeff Ross wrote: Hello, We have a logically replicated table on RDS that is 39 G in size on both the publisher (10.21) and the subscriber (12.8). The replication slots on the publisher are all marked as active and the lsns are current so no lag. Other tables on the sub

Re: Max sane value for join_collapse_limit?

> On Jun 3, 2022, at 4:19 AM, Andreas Joseph Krogh wrote: > > Hi, I have set join_collapse_limit = 12 in production, but I'm thinking about > raising it to 16. > On modern HW is there a “sane maximum” for this value? > I can easily spare 10ms for extra planning per query on our workload, is 1

Re: GIN theory

theory/explanation about GIN index: https://github.com/postgres/postgres/blob/master/src/backend/access/gin/README https://postgrespro.com/blog/pgsql/4261647 https://pgpedia.info/g/gin.html On Fri, Jun 3, 2022 at 2:34 PM huangning...@yahoo.com < huangning...@yahoo.com> wrote: > Hi: > > I want to

Re: unoptimized nested loops

Thank you to David, Jeff and Tom for your responses. Tom's response has made me rethink my question. I may have provided too much information, in the effort to anticipate suggestions. Let me rephrase: I have two tables, a parent (named "metadata") and a child (named "data"). Each table has

GIN theory

Hi: I want to know the time that create a gin index for a array, or some theory about gin index? Thanks

Max sane value for join_collapse_limit?

Hi, I have set join_collapse_limit = 12 in production, but I'm thinking about raising it to 16. On modern HW is there a “sane maximum” for this value? I can easily spare 10ms for extra planning per query on our workload, is 16 too high? Thanks. -- Andreas Joseph Krogh CTO / Partner -