[Geocoding] Large index crashes postgres

[Frans Hals]

Brian,

which one of them  is osm_type "way" in placex? ST_LineSting?
These are the geometry values that are leaking the memory...

2010/3/27 Brian Quinion <openstreetmap at brian.quinion.co.uk>:
>
>> Do you know the answer of the last question above?
>
> It changes as it goes down the table, it's a right mixture.
>
>  ST_LineString   |            2 |  5398548

>  ST_Point        |              | 20648939
>  ST_MultiPolygon |              |     6188
>  ST_Polygon      |              |  8054680
>
>
> One thing you could try is indexing each geometry type in turn and
> watch the memory usage.
>