This article discusses accelerating retrieval of coordinate points in PostGIS using GiST indexes and demonstrates it using example code.
This article briefs the business requirements of logistics tracking systems, and analyzes PostgreSQL's performance using the Cainiao courier tracker app.
This article discusses the performance of nearest neighbor queries in PostgreSQL and talks about optimization measures that address performance issues.
This article discusses the nearest-neighbor enhancement added in PostgreSQL 9.1 for sorting GiST indexes with sample code and examines the performance using test data.
In today's retail industry, data must be used to its greatest value if online and offline business are to be integrated and inventories optimized.