> Sankar P <sankar.curiosity@gmail.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