3 ms·
Despite the title saying PostgreSQL this doesn't go into any PostgreSQL specific topics like function based indexes, or partial indexes. The stuff here is univ
by ars 11y ago
Despite the title saying PostgreSQL this doesn't go into any PostgreSQL specific topics like function based indexes, or partial indexes.
The stuff here is universal and applies to any database (perhaps with some terminology change).
- officialchicken 11y agoA simple demonstration of spatial indexes used with WKT/WKB or various shape and geometry column types in GIS databases would be helpful in understanding how an index is used in a typical spatial query (e.g. distance, contains/bounds, or intersects). There are also video and image (e.g. histogram) indexes in postgres as well, but they're much more rare.