postponing index updates in a transaction

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: postponing index updates in a transaction
Date: 2002-12-11 09:27:06
Message-ID: 3DF704EA.80901@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

To speed up the inserting of many rows, is there a way to turn off any
index update being done while inside a transaction and have the index be
update at COMMIT?

Something similar to the "initially deferred" constraint.

Thanks,

Jc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bret Hughes 2002-12-11 09:39:40 Re: postponing index updates in a transaction
Previous Message frbn 2002-12-11 08:24:43 Re: createlang fails