I tried a vectorized PostgreSQL 19 on a laptop: 18 to 21% faster, and a 16,000-value ANY 948 times slower

Name: I tried a vectorized PostgreSQL 19 on a laptop: 18 to 21% faster, and a 16,000-value ANY 948 times slower
Uploaded: 2026-10-09T00:00:00.000Z
Duration: 1 min 7 s
Description: Narrated: a vectorized executor for PostgreSQL 19 measured on a laptop. ClickBench improves by 18 to 21%, but a 16,000-value = ANY goes from 73 milliseconds to 69 seconds because the cost model counts it as a single comparison.

Narrated: a vectorized executor for PostgreSQL 19 measured on a laptop. ClickBench improves by 18 to 21%, but a 16,000-value = ANY goes from 73 milliseconds to 69 seconds because the cost model counts it as a single comparison.

Length: 1:07
Published: 8 October 2026

PostgreSQLBases de datosRendimientoBenchmark

This reel sums up I tried a vectorized PostgreSQL 19 on a laptop: 18 to 21% faster, and a 16,000-value ANY 948 times slower, where the method, the tables and what did not work are.

Read the article Open in the viewer