Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[GENERAL] postponing index updates in a transaction

0 views
Skip to first unread message

Jean-Christian Imbeault

unread,
Dec 11, 2002, 4:33:19 AM12/11/02
to
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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

0 new messages