Обсуждение: Which is faster, create index after many inserts or before?

Поиск
Список
Период
Сортировка

Which is faster, create index after many inserts or before?

От
Eric Frazier
Дата:
Thanks,

Eric


Re: Which is faster, create index after many inserts or before?

От
David Olbersen
Дата:
After. Otherwise as you INSERT the index will be updated, which can slow down
massive inserts.

See: http://www.postgresql.org/devel-corner/docs/postgres/populate.html

-- Dave