I did. 64-bit cmd.exe, 64-bit JVM and -Xmx 16000. It uses all the
physically available memory (nearly 16GB) and throws the exception when
that limit is reached.
2011/12/26 Brett Henderson br...@bretth.com
On 26 December 2011 01:43, Michel Seuthe m.seu...@googlemail.com wrote:
Ya, I used a
Wow, okay. Perhaps the planet is just too big now. I've never had enough
RAM to run it properly so don't have any numbers. I've always had to use
nodeLocationStoreType=TempFile which is still faster than building
linestrings in the database itself. It may also be worth experimenting
with
On 26 December 2011 01:43, Michel Seuthe m.seu...@googlemail.com wrote:
Ya, I used a similar statement. It took a few hours to build the
linestrings for germany.
I tried to use osmosis to build the geometries, but it always threw
SystemOutOfMemory Exception when the linestring column was
Hi Michel,
Yes, there is redundant data stored in the pgsnapshot schema. It's there
for performance reasons. If you compare the pgsnapshot schema to the
earlier pgsimple schema you'll notice that the way.nodes column is new, but
that the way_nodes table has always existed. Both way-node
Thanks for your detailed reply, Brett. Makes sense.
2011/12/22 Brett Henderson br...@bretth.com
Hi Michel,
Yes, there is redundant data stored in the pgsnapshot schema. It's there
for performance reasons. If you compare the pgsnapshot schema to the
earlier pgsimple schema you'll notice
I got a question left... If i add the linestring-column to the ways table
_after_ I imported all the data, is there a way to fill this column without
re-import everything?
Cheers.
2011/12/22 Michel Seuthe m.seu...@googlemail.com
Thanks for your detailed reply, Brett. Makes sense.
Hey,
I just imported german OSM-data to my postgre-Server. By looking at the
data i was wondering what the table *way_node* stands for? I expected the
reference to the nodes which representing the way in the *nodes*-column in
the *ways *table. Isn't that correct?
Cheers.
Hi Michel,
On 21.12.2011 13:34, Michel Seuthe wrote:
I just imported german OSM-data to my postgre-Server. By looking at the
data i was wondering what the table /way_node/ stands for?
Which schema did you use? APIDB, simple schema, snapshot schema? they
are all slightly different so it is
Hi Michel,
On 21.12.2011 13:45, Michel Seuthe wrote:
whoops sorry, I used the pgsnapshot schema.
Please use reply all so that the mailing list gets your messages as well.
Yes, in the snapshot schema the way_node table describes what nodes make
up a way, just like you expected.
Bye
Igor
Michel,
please reply to the list, _not_ just to me in person. Thank you.
On 21.12.2011 14:00, Michel Seuthe wrote:
Hmm okay, but that means all references from the way to it's nodes are
stored in way_nodes and in way table. Which would be a mass of redundant
data...
Why do you think it is
2011/12/21 Igor Podolskiy igor.podols...@vwi-stuttgart.de
Michel,
please reply to the list, _not_ just to me in person. Thank you.
On 21.12.2011 14:00, Michel Seuthe wrote:
Hmm okay, but that means all references from the way to it's nodes are
stored in way_nodes and in way table. Which
2011/12/21 Igor Podolskiy igor.podols...@vwi-stuttgart.de
Michel,
please reply to the list, _not_ just to me in person. Thank you.
On 21.12.2011 14:00, Michel Seuthe wrote:
Hmm okay, but that means all references from the way to it's nodes are
stored in way_nodes and in way table. Which
Hi Michel,
For example:
SELECT id, nodes FROM ways WHERE id=55579416;
delivers:
55579416; {299810549,299809848,299810550,259983366}
SELECT way_id, node_id, sequence_id FROM way_nodes WHERE way_id=55579416;
delivers:
55579416;299810549;0
55579416;299809848;1
55579416;299810550;2
No Problem Igor.
I was just confused by this fact. I expected more, but the table would just be
about 26gb big if you import the full planet.osm. So it should be no problem.
Thanks anyways.
Happy Holidays.
Am 21.12.2011 um 15:55 schrieb Igor Podolskiy:
Hi Michel,
For example:
SELECT
14 matches
Mail list logo