[postgis-users] COPY too slow when geometry column is indexed

[Markus Schaber]

Hi, Ries,

Ries van Twisk wrote:

> Create a partial index per database population, so current indexes
> doesn't affect indexes of the same table that are
> already in your DB.
> Then after your 200.000 record population you create the index again,
> this should be much faster...

This only works if you also use the partial index criteria in the
queries. Maybe table constraints will work, too. If not, PostgreSQL will
not recognize that the partial index in fact covers the whole table, and
use sequential scans...

Markus