Postgres Pro
Downloads
Home   >   mailing lists

Removing a key from jsonb is sloooow - Mailing list pgsql-general

From Volkan Unsal
Subject Removing a key from jsonb is sloooow
Date
Msg-id CAMcqKmnaJS_xnuKY6j2e+uZbHXhrtDx6SaDcRp-ZMYPfAbsOKw@mail.gmail.com
Whole thread Raw
Responses Re: Removing a key from jsonb is sloooow  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Removing a key from jsonb is sloooow  (Tumasgiu Rossini <rossini.t@gmail.com>)
Re: Removing a key from jsonb is sloooow  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
I'm trying to remove a key from a jsonb column in a table with 10K rows, and the performance is abysmal. When the key is missing, it takes 5 minutes. When the key is present, it takes even longer.

Test with non-existent key:

>> update projects set misc = misc - 'foo';
Time: 324711.960 ms (05:24.712)

What can I do to improve this?

pgsql-general by date:

Previous
From: Rory Campbell-Lange
Date:
Subject: Re: How to run a task continuously in the background
Next
From: Adrian Klaver
Date:
Subject: Re: Removing a key from jsonb is sloooow