Re: Loading 500m json files to database - Mailing list pgsql-general

On 3/23/20 5:26 PM, pinker wrote:
> Hi,
> json_parts it's just single table with 2 column:

Well I misread that.

> 
>                                                    Table "public.json_parts"
>    Column   |  Type   | Collation | Nullable |                Default
> | Storage  | Stats target | Description
>
-----------+---------+-----------+----------+----------------------------------------+----------+--------------+-------------
>   id        | integer |           | not null |
> nextval('json_parts_id_seq'::regclass) | plain    |              |
>   json_data | jsonb   |           |          |
> 
> no indexes, constraints or anything else
> 
> 
> 
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com