[GRASSLIST:4603] Re: v.to.db - time

[Radim Blazek]

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