Stop writing so many subqueries, think in joins; the poor planner!
SELECT DISTINCT ON (a.id) a.id AS a_id, b.id AS b_id
FROM a
JOIN b
ON ST_Contains(b.shape, a.shape)
WHERE b.kind != 1
Also, the DISTINCT ON syntax (PgSQL custom) lets you winnow a result
set down to just one of the inputs.
P.
Many people like looking at maps that show flight paths. I’ve just posted a
tutorial outlining an approach which gives the user the ability to set the
degree of bend or flex in the curve, the number of vertices (useful for time
series animations) and a break value which splits the linestring
Nice work Mark, well done, would you have a version to perform Bezier spline
interpolation?
Regards,
Sent from my iRon
On Mar 4, 2015, at 23:30, Tahir Tamba tahir.ta...@gmail.com wrote:
Thank you Mark for sharing this usefull tips.
Regards.
2015-03-04 23:07 GMT-05:00 Mark Wynter
Thank you Mark for sharing this usefull tips.
Regards.
2015-03-04 23:07 GMT-05:00 Mark Wynter m...@dimensionaledge.com:
Many people like looking at maps that show flight paths. I’ve just posted
a tutorial outlining an approach which gives the user the ability to set
the degree of bend or
Hello,
I have a query plan optimization question. It is formatted nicely on
http://stackoverflow.com/questions/28856452/postgres-not-using-gist-index-in-lateral-join
But here is a copy for the archive:
Here is the setup:
CREATE EXTENSION postgis;
DROP TABLE IF EXISTS A;
DROP TABLE IF EXISTS