Home > mailing lists

Re: Which is faster, create index after many inserts or before? - Mailing list pgsql-novice

From	David Olbersen
Subject	Re: Which is faster, create index after many inserts or before?
Date	March 14, 2001 20:46:47
Msg-id	Pine.LNX.4.31.0103141430250.3164-100000@bubbles.electricutopia.net Whole thread Raw
In response to	Which is faster, create index after many inserts or before? (Eric Frazier <ef@kwinternet.com>)
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Eric Frazier
Date: 14 March 2001, 20:28:48
Subject: Which is faster, create index after many inserts or before?

From: Joel Burton
Date: 14 March 2001, 22:35:25
Subject: Re: SELECT query

Re: Which is faster, create index after many inserts or before? - Mailing list pgsql-novice

Previous

Next