| From: | Sankar P <sankar(dot)curiosity(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, mlewis(at)entrata(dot)com |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Importing a Large .ndjson file |
| Date: | 2020-06-19 03:52:38 |
| Message-ID: | CAMSEaH4fsyeFOtUmAGeXTOU-UUEqOaanG1OqNmrFNBKwa3iY0g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Sankar P <sankar(dot)curiosity(at)gmail(dot)com> 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 index after-the-fact
> is often cheaper than updating it incrementally. For GIN indexes
> specifically, see also
>
> https://www.postgresql.org/docs/current/gin-tips.html
Thanks guys.
--
Sankar P
http://psankar.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Förster | 2020-06-19 05:30:59 | Re: Netapp SnapCenter |
| Previous Message | Michael Paquier | 2020-06-19 02:01:07 | Re: Parallel safety of contrib extensions |