Get the latest tech news
PostgreSQL Sees Up To 4x Query Performance With SIMD-Optimized JSON Escaping
For those making use of JSON data with the PostgreSQL database server, now merged code to make use of SIMD for JSON escaping has shown up to a 4x improvement for query performance when dealing with lots of JavaScript Object Notation data.
For those making use of JSON data with the PostgreSQL database server, now merged code to make use of SIMD for JSON escaping has shown up to a 4x improvement for query performance when dealing with lots of JavaScript Object Notation data. David Rowley who pursued this SIMD-optimized JSON escaping explained in the commit merged yesterday: With these changes, some benchmarking has shown a query performing nearly 4 times faster when escaping a JSON object with a 1MB text property.
Or read this on Phoronix
