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

From pinker
Subject Re: Loading 500m json files to database
Date
Msg-id 1585009593934-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Loading 500m json files to database  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Loading 500m json files to database  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi,
json_parts it's just single table with 2 column:

                                                  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



pgsql-general by date:

Previous
From: pinker
Date:
Subject: Re: Loading 500m json files to database
Next
From: Adrian Klaver
Date:
Subject: Re: Loading 500m json files to database