[GRASSLIST:4601] v.to.db - time

GRASS GRASS user
1

Hi,

I have a vector layer which consists 132 884 lines.
Attributes are stored in PostgreSQL.

I have updated the column 'length'

$ v.to.db roads type=line opt=length units=k col1=length

it took more then 10 hours!

When I tried to export this layer to PostGIS it took
more than 15 hours!

Is it 'normal'?

I have Pentium M 1.5GHz, 512MB RAM.

Best regards,

Martin

---
Martin Landa <landa@gama.fsv.cvut.cz> * http://gama.fsv.cvut.cz/~landa *
CTU Prague, Faculty of Civil Engineering, Czech Republic

2

On Thursday 21 October 2004 16:18, Martin Landa wrote:

Hi,

I have a vector layer which consists 132 884 lines.
Attributes are stored in PostgreSQL.

I have updated the column 'length'

$ v.to.db roads type=line opt=length units=k col1=length

it took more then 10 hours!

When I tried to export this layer to PostGIS it took
more than 15 hours!

Is it 'normal'?

I have Pentium M 1.5GHz, 512MB RAM.

Try to create index on key (category) column.

Radim