Hi Stefan,
Thank you for your help and for the links.
It will help me a lot in my future works.
Regards
Arnaud
On Wed, Dec 15, 2010 at 2:30 PM, Stefan Keller wrote:
> Hi Arnaud,
>
> Sorry for coming late to this discussion.
>
> I can offer another random generator (see below) as well as a
> w
Hi Arnaud,
Sorry for coming late to this discussion.
I can offer another random generator (see below) as well as a
well-defined benchmark based on real world data: "The HSR Texas
Spatial Database Benchmark" (see http://www.gis.hsr.ch/wiki/Benchmark
). If you want larger real world data then one c
On Fri, Nov 26, 2010 at 09:38:09AM +0100, Arnaud Vandecasteele wrote:
> I understand better the interest of the Gis Index ! Thank you for your
> answer.
> I do not want to evaluate the postgis vs other database, just the time
> the queries will take for 1000 10 000 or more objects.
> The use case
I understand better the interest of the Gis Index ! Thank you for your answer.
I do not want to evaluate the postgis vs other database, just the time
the queries will take for 1000 10 000 or more objects.
The use case will be this one :
We have several thousands of vessels and every 5 seconds I mu
On Fri, Nov 26, 2010 at 09:15:27AM +0100, Arnaud Vandecasteele wrote:
> Thanks you for your answers.
> I can understand your objections but how can I make this process better ?
>
> Also, my tests gave me some strange results.
> For the first set, I did the process explain before without a gis inde
Thanks you for your answers.
I can understand your objections but how can I make this process better ?
Also, my tests gave me some strange results.
For the first set, I did the process explain before without a gis index (gist).
And for the seconde one I built a gis index.
I was expected better res
Oh, no, the results will still be biased by the particular polygon
data. You'll have a "how postgis performs doing p-i-p against a world
countries file" result. Which isn't a generic "how postgis performs
doing p-i-p" result by any stretch of the imagination.
P.
On Thu, Nov 25, 2010 at 10:30 AM,
To eliminate the problemas presented by Paul, create a regular grid of 1x1
degrees and populate it randomly with points. Then make your test. All
square polygons will have 4 vertexes and the test is "less biased".
George
On Thu, Nov 25, 2010 at 3:22 PM, Paul Ramsey wrote:
> Depends on who you t
Depends on who you think the results will be valid for. The
countries-of-the-world is a somewhat non-standard GIS collection given
the wide variation in polygon sizes, the large numbers of vertices in
the larger polygons, and the extreme coverage of the overall area that
the bounding boxes of the l
Hi all,
I've to do a quick benchmark of postgis. The case is to check if a
point is inside (or not) a polygon.
To do so, I've uploaded in my database a big shapefile which contains
all the world's countries.
After that I've made a simple stored function [1]. This one, take two
arguments :
1 - The
10 matches
Mail list logo
