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

From: David Olbersen <dave(at)slickness(dot)org>
To: Eric Frazier <ef(at)kwinternet(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Which is faster, create index after many inserts or before?
Date: 2001-03-14 22:31:36
Message-ID: Pine.LNX.4.31.0103141430250.3164-100000@bubbles.electricutopia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2001-03-15 00:35:18 Re: SELECT query
Previous Message Eric Frazier 2001-03-14 22:21:12 Which is faster, create index after many inserts or before?