On Thu, 3 Oct 2002, Shridhar Daithankar wrote: > Our major concern remains load time as data is generated in real time and is > expecetd in database with in specified time period.
If your time period is long enough, you can do what I do, which is to use partial indexes so that the portion of the data being loaded is not indexed. That will speed your loads quite a lot. Aftewards you can either generate another partial index for the range you loaded, or generate a new index over both old and new data, and then drop the old index. The one trick is that the optimizer is not very smart about combining multiple indexes, so you often need to split your queries across the two "partitions" of the table that have separate indexes. > Shall I subscribe to performance? Yes, you really ought to. The list is [EMAIL PROTECTED] cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly