Thread: postponing index updates in a transaction

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

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