Disable index updates for bulk inserts?

akaraivanov · #1 (**permalink**) 10-05-09, 07:25

Hi,

I would like to run a program that populates the db with a lot of initial data (for testing).
The data is generated so I cannot load it. I can switch consistency check off but would be really nice to disable update of indexes while I data is inserted and enable indexes at the end (at that time indexes should be regenerated of course).
I browsed the docs of latest version and seems simply not possible.

Does anyone have an idea if that is possible somehow?

Thanks
Alex.

dav1mo · #2 (**permalink**) 10-05-09, 08:10

drop the indexes, create the indexes

akaraivanov · #3 (**permalink**) 10-05-09, 08:14

Yes, that is a possibility but it is a very clumsy way to do it. I was looking for something more elegant.

Marcus_A · #4 (**permalink**) 10-05-09, 08:58

Quote:

Originally Posted by akaraivanov

Yes, that is a possibility but it is a very clumsy way to do it. I was looking for something more elegant.

Dropping the index is the only option. You can disable FK's, but not indexes. The only exception would be an index automatically created with a PK or Unuque Contraint, that would be dropped if you drop the constraint.

However, if you use the load utility, the indexes will not be built as you go, they will be rebuilt at the end in a seperate step all on once.