from there.
Thanks a lot :)
--
Sankar P
http://psankar.blogspot.com
sible with any other extra index creation in postgres.
Any suggestions ? Thanks.
--
Sankar P
http://psankar.blogspot.com
> Sankar P writes:
> > I spoke too soon. While this worked fine when there were no indexes
> > and finished within 10 minutes, with GIN index on the jsonb column, it
> > is taking hours and still not completing.
>
> There's the generic advice that building an
e jsonb column, it
is taking hours and still not completing.
--
Sankar P
http://psankar.blogspot.com
e with a few million records already ?
3) There are various types of indexes. I am using GIN based on some
short-term googling. Are there any good blog posts, links, tutorials,
courses etc. that you have found useful in understanding the postgres
jsonb performance tuning ?
Thanks.
--
Sankar P
http://psankar.blogspot.com
> It looks like plain old COPY would do this just fine, along the lines
> of (in psql)
>
> \copy myTable(content) from 'myfile.ndjson'
>
Indeed. Thanks.
--
Sankar P
http://psankar.blogspot.com
the records to be inserted to the `content` field of my
postgres table.
What is the best way to do this on a postgresql database, deployed in
kubernetes, with a 1 GB RAM allocated ?
I can probably write a that would read this file line-by-line and
INSERT into the database, in a transaction. But that
