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
Re: Removing a key from jsonb is sloooow
Re: Removing a key from jsonb is sloooow
List pgsql-general
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