Re:Postgres indexes under the hood
by Walf on Saturday January 27, 2018 @09:14AM
(#16246274)
How I wish you Americans had just left them as "indices". Almost every time I read it as the verb.
[ Parent
| on HN ]
OP here.
This is funny. On the rest of my blog post I use indices. For this post, I went with indexes because that's what PG calls them in the docs.
I feel your pain.
Re:Postgres indexes under the hood
by bunderbunder on Saturday January 27, 2018 @10:00AM
(#16246420)
There may be an odd semantic distinction that doesn't translate.
I (native US English speaker) typically interpret "indexes" as the plural of index as in "structure you use for fast key-value lookup". I interpret "indices" as the plural of index as in "lookup key".
Laughed out loud. We used "indexes" and "indices" all over a code base, methods/classes and doc. It was a real mess to true up to one.
Re:Postgres indexes under the hood
by ComputerGuru on Saturday January 27, 2018 @09:41AM
(#16246362)
American here, and I agree. But growing up, it was always indices.
Isn’t OED British? They recently took their dictionary behind a paywall (!!), but they recommend “indexes” while it appears accepted that it is the Americanized spelling nonetheless.