“PostgreSQL Anonymizer is an extension that hides or replaces personally identifiable information (PII) or commercially sensitive data from a PostgreSQL database.”
Now with Image Blurring feature:
“But our new Image Blurring capability preserves visual data for testing while protecting privacy:
SECURITY LABEL FOR anon ON COLUMN user.photo
IS ‘MASKED WITH FUNCTION anon.image_blur(photo,5.0)’;”
https://www.postgresql.org/about/news/postgresql-anonymizer-21-blurring-images-3061/
“PostgreSQL 17 brings an AVX-512 optimized bit_count() function. The AVX-512 work has seen a reported 48% performance improvement by Intel.
PostgreSQL 17 also brings SIMD-optimized JSON escaping for up to 4x the query performance.
PostgreSQL 17 also has a new internal memory structure for vacuum that consumes up to 20x less memory! Plus improvements to the I/O layer can yield up to 2x better write throughput for high concurrency workloads thanks to write-ahead log (WAL) processing enhancements. Plus there are other performance improvements too.”
/root 