Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group