[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Maposmatic-dev] PostGIS help for MapOSMatic

From: Thomas Petazzoni
Subject: [Maposmatic-dev] PostGIS help for MapOSMatic
Date: Sat, 27 Feb 2010 12:36:40 +0100

Hi Vincent, Jean-Christophe, Guilhem and Sébastien,

[ This message is CC'ed to the development mailing list of MapOSMatic,
  which is why I'm writing to you in english. Please keep the list in
  the CC list even if you're not subscribed. I'll moderate your
  messages manually. Thanks! ]

I'm writing to you concerning a PostgreSQL/PostGIS request optimization
problem we have in MapOSMatic ( The request
in question is the one that gives us the list of the streets and the
squares they intersect for a given city.

Currently, for a city like Toulouse, the request takes 4 minutes and 39
seconds, but our experiment show that it could be optimized down to 3.2
seconds. But we don't know exactly how to generalize our experiments of

Inside of writing a long e-mail, I've written a detailed explanation of
the request, the problem and the analysis we've done so far at

If you have the time, could you have a look and tell us what we are
doing wrong ? Solving this problem would probably allow us to limit the
load on the server and to generate maps for larger cities. Of course,
if you need details about the request or the environment, don't

Thanks a lot for your help,

Thomas Petazzoni               
Promouvoir et défendre le Logiciel Libre
Logiciels Libres à Toulouse    

Attachment: signature.asc
Description: PGP signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]