4 ms·
Just to be a pedant, the JSONB format as I understand is marginally slower at inserts and orders of magnitude faster at everything else...
by andy_ppp 11y ago
Just to be a pedant, the JSONB format as I understand is marginally slower at inserts and orders of magnitude faster at everything else...
- robconery 11y agoIt's fractionally slower, true, because of the serialization hit (string to binary). The real juice comes from the GIN index - and if you apply it to specific columns instead of a complete document, you have a rocket ship on read.
- creshal 11y ago> It's fractionally slower, true, because of the serialization hit (string to binary). And with JSON columns you have to serialize on accesses, which is a lot slower in the read-mostly tests.
- SilasX 11y agoStupid question: isn't that the typical result of indexing? Slower writes for (much) faster lookups?