I am trying to run the following query thousands of times per second to determine which is any polygon contains the passed in point.
SELECT * from areas WHERE poly @> ?
Poly is the name of the polygon field and it has a GIST index on it.
I am wondering if I would see any performance benefit from using PostGIS over the regular postgress geospatial index for this simple query. I am using Amazon RDS to host postgress and with 3 xl read replicas I can only get about 20,000 transactions per second and I need to triple that. I have a webapp that makes the requests to postgres. At 20k tps all the postgress replicas are at 100% cpu.
Any help would be appreciated.
أكثر...
SELECT * from areas WHERE poly @> ?
Poly is the name of the polygon field and it has a GIST index on it.
I am wondering if I would see any performance benefit from using PostGIS over the regular postgress geospatial index for this simple query. I am using Amazon RDS to host postgress and with 3 xl read replicas I can only get about 20,000 transactions per second and I need to triple that. I have a webapp that makes the requests to postgres. At 20k tps all the postgress replicas are at 100% cpu.
Any help would be appreciated.
أكثر...