On lundi 19 mars 2012, didier2020 wrote:
j'ai enregistré la requete dans un fichier mais quand j'utilise
psql -d osm -U didier -f monfichier.sql
j'ai un message erreur : erreur de syntaxe sur ou près de « SELECT »
Tu peux nous faire passer ton fichier monfichier.sql ?
Peut-être a-t-il été
Le lundi 19 mars 2012 à 17:01 +0100, sly (sylvain letuffe) a écrit :
On lundi 19 mars 2012, didier2020 wrote:
j'ai enregistré la requete dans un fichier mais quand j'utilise
psql -d osm -U didier -f monfichier.sql
j'ai un message erreur : erreur de syntaxe sur ou près de « SELECT »
Tu
#4307: Weird behavior when changing tags (ie name_1=* to alt_name=*)
+---
Reporter: compdude | Owner: potlatch-dev@…
Type: defect | Status: closed
On 3/18/2012 4:07 PM, Kai Krueger wrote:
sylvain letuffe wrote
It turned out that the index on the pending field wasn't used at all and
led
to a full scan of the planet_osm_ways table, increasing noticeably the
diff
import.
I think I have seen that one before as well. If I remember correctly,
Am 19.03.2012 12:37, schrieb Lynn W. Deffenbaugh (Mr):
And should I be doing a periodic vaccuum to clean out accumulated
cruft? I was thinking that not too much in the osm planet would be
deleting, but maybe my assumption is incorrect?
Yes and yes.
osm2pgsql does not update rows, it deletes
gis= explain select id from planet_osm_ways where pending;
Index Scan using planet_osm_ways_idx on planet_osm_ways
(cost=0.00..916513.78 rows=43724 width=4)
This is what I've got after a re-index :
gis=# explain select id from planet_osm_ways where pending;
Hi,
Thank you for your interest in applying for GSoC with Openstreetmap. This
list will be fine to ask questions.
Here are a few suggestions to get you started:
- It is important to understand the fundamentals of what OSM is, so if you
have not done so before, please start by creating an
7 matches
Mail list logo