-
-
Notifications
You must be signed in to change notification settings - Fork 180
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
For --auto-bounds quick
, use ST_EstimatedExtent
instead of ST_Extent
for quicker results
#1206
Comments
martin/martin/src/pg/query_tables.rs Line 228 in e304678
I'm a little bit confused. Could |
@sharkAndshark this was done in #300 by @HackJack-101 a while ago, addressing bug #299. I may need to dig deeper though to understand why it was done |
I made a test on a point table which has only one point. And seems that SELECT
st_geometrytype ( ST_SetSRID ( ST_Extent ( geom ), 4544 ) ) AS type1,
st_geometrytype ( ST_Extent ( geom ) ) AS type2 ,
st_geometrytype( ST_EstimatedExtent('public','project_copy1','geom')) as type3
FROM
project_copy1
-- type1: ST_Point type2: ST_Point type3: ST_Polygon |
Modify PG querying to use a quicker extent function when the bound check is set to
quick
Implementation is easy: simply add another bool param to
calc_bounds
, and use a different function depending on that parammartin/martin/src/pg/query_tables.rs
Line 214 in e304678
The text was updated successfully, but these errors were encountered: