Re: postponing index updates in a transaction

От:

Bret Hughes <bhughes@elevating.com>

Дата:

11 декабря 2002 г. в 04:40:30

On Wed, 2002-12-11 at 03:27, Jean-Christian Imbeault wrote:
> 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
> 
I don't think so.

The docs refer to this issue and suggest dropping the index, doing the
updates and then recreating the index.  using copy from is way faster
than individual inserts too.

Bret

postponing index updates in a transaction

От:

Jean-Christian Imbeault <jc@mega-bucks.co.jp>

Дата:

11 декабря 2002 г. в 04:28:21

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