On Jun 15, 2006, at 9:45 PM, Toru SHIMOGAKI wrote:
NTT has some ideas about index creation during a large amount of
data loading. Our approach is the following: index tuples are
created at the same time as heap tuples and added into heapsort. In
addition, we use old index tuples as sorted l
NTT has some ideas about index creation during a large amount of data loading.
Our approach is the following: index tuples are created at the same time as heap
tuples and added into heapsort. In addition, we use old index tuples as sorted
list if the target table has already data. It is not nece
It's not uncommon for index creation to take a substantial amount of
time for loading data, even when using the 'trick' of loading the data
before building the indexes. On fast RAID arrays, it's also possible for
this to be a CPU-bound operation, so I've been wondering if there was
some reasonable