Hi, Your current query actually process your 10K rows, it is a bit of an overkill if only a few row contains the key you want to delete. Depending on how big your json data is, this could be problematic.
Have you considered adding a where clause to your query ? Also, maybe you could create an index on your jsonb column to improve the identification of rows which contains the key you want to delete ? Le mer. 17 juil. 2019 à 16:31, Volkan Unsal <spockspla...@gmail.com> a écrit : > 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? >
