I'm trying to determine if the response time we're seeing on a query is
reasonable or if there's anything we can do to speed it up. Looking for advice
and/or a reality check.
In general, we benefit from dicing our large polygon layers to speed up
intersection queries (a big thanks to Paul Ra
Hi,
I'm unsure how good ST_Transform performs. Did you consider adding a
partial functional index like described in [1] ?
-S.
[1] http://postgis.refractions.net/documentation/manual-1.5/ST_Transform.html
2012/9/18 Shira Bezalel :
>
> I'm trying to determine if the response time we're seeing on
There are few things left to tweak here...
your streams are (presumably) relatively small features?
your input polygon is very small and simple, so that's not the problem
This is one of the few cases where I actually wonder about PostgreSQL
tuning parameters: is your shared_buffered increased to a
y to
bring the data into cache ahead of time?
Shira
- Original Message -
From: "Paul Ramsey"
To: "PostGIS Users Discussion"
Sent: Tuesday, September 18, 2012 5:47:36 AM
Subject: Re: [postgis-users] How to speed up a spatial intersection where the
intersec
nday, September 17, 2012 11:23:13 PM
Subject: Re: [postgis-users] How to speed up a spatial intersection where the
intersecting polygon is drawn on-the-fly?
Hi,
I'm unsure how good ST_Transform performs. Did you consider adding a
partial functional index like described in [1] ?
-S.
rom: "Paul Ramsey"
> To: "PostGIS Users Discussion"
> Sent: Tuesday, September 18, 2012 5:47:36 AM
> Subject: Re: [postgis-users] How to speed up a spatial intersection where
> the intersecting polygon is drawn on-the-fly?
>
>
> There are few things left
ion"
Sent: Tuesday, September 18, 2012 11:25:41 AM
Subject: Re: [postgis-users] How to speed up a spatial intersection where the
intersecting polygon is drawn on-the-fly?
Well, I still feel that 3.5 seconds is too long for pulling and
intersecting 2 features, *assuming* those features
that I can send to you or
> place on a FTP site.
>
> Shira
>
>
> From: "Paul Ramsey"
> To: "PostGIS Users Discussion"
> Sent: Tuesday, September 18, 2012 11:25:41 AM
>
> Subject: Re: [postgis-users] How to speed up a spatial i