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

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

From
Eric Frazier
Date:
Thanks,

Eric


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

From
David Olbersen
Date:
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