Re: json on child table or not - Mailing list pgsql-general

From PegoraroF10
Subject Re: json on child table or not
Date
Msg-id 1559326883285-0.post@n3.nabble.com
Whole thread Raw
In response to Re: json on child table or not  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Yes, they are jsonb.
Their length varies between 400 and 2.000 chars, when using
pg_column_size(jsonb field). When casting to text it goes to 1.800 to 3.500
of length.
I didn´t set any storage strategie for that table or field. It´s defined as
x for storage.
No, I don´t have any index on that field.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html



pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: json on child table or not
Next
From: Morris de Oryx
Date:
Subject: Re: Questions about btree_gin vs btree_gist for low cardinality columns