BestHub
Sign in
Tag

array indexing

0 views collected around this technical thread.

IT Services Circle
IT Services Circle
Feb 15, 2025 · Fundamentals

Why Array Indices Start at Zero: History, Memory Layout, and Practical Benefits

Array indexing begins at zero due to historical decisions dating back to early languages like B and C, memory layout efficiencies that avoid extra subtraction, mathematical elegance of half-open intervals, and practical advantages in loops, hashing, multidimensional arrays, and language design, making zero-based indexing the de‑facto standard.

C languagearray indexingmemory layout
0 likes · 8 min read
Why Array Indices Start at Zero: History, Memory Layout, and Practical Benefits
Efficient Ops
Efficient Ops
Jul 9, 2017 · Databases

How Alibaba Scales Real‑Time Deduplication and Targeted Ads with PostgreSQL

This article explains how Alibaba Cloud leverages PostgreSQL’s GIN indexes, array types, and pg_trgm extension to achieve real‑time deduplication of massive guide articles, precise ad targeting, TOB profiling, arbitrary field combination, and fuzzy matching, delivering millisecond‑level latency while drastically reducing hardware requirements.

GIN indexPostgreSQLTOB profiling
0 likes · 18 min read
How Alibaba Scales Real‑Time Deduplication and Targeted Ads with PostgreSQL