Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with optimization
Search options not deleted
user 133514
Use this tag when referring to improving or optimizing a process such as a script, application or software.
2
votes
Why does rescaling by 1.0 speed up this PostGIS query
Because ST_Rescale doesn't scale the raster by that amount, but to that amount, unlike OpenCV.
I guess that means the way I've proposed is slower in PostGIS than OpenCV.
- 181
1
vote
1
answer
57
views
Why does rescaling by 1.0 speed up this PostGIS query
To preface, I'm not sure if it matters, but I'm using PostgreSQL 11 with PostGIS 2.5 (through Docker on Windows) and accessing it with Python through PsycoPG2.
My raster has the recommended index on …
- 181